List:General Discussion« Previous MessageNext Message »
From:Joshua J. Kugler Date:April 6 2004 1:44am
Subject:Re: MSSQL Server to MYSQL migration problems
View as plain text  
MySQL is very stable on large databases...I would suspect inefficient indexes.  
What does your query look like?  What is the output when you put "EXPLAIN" in 
front of your query?

I don't know anything about SQLYog blob display, so can't comment there.

j----- k-----

On Monday 05 April 2004 05:41 pm, Rodrigo Galindez said something like:
> Im using SQLYog to display results. It lets me to display blob data
> types. By the way, i was trying to do some queries with phpmyadmin ...
> but, it "hungs" ... hmmm ... inestability with large databases in mysql
> maybe ? :S
>
> Joshua J. Kugler wrote:
> >You "can't?"  How are you trying to display? What are you using?  A CGI
> >script? A database utility?  Something else?  We need  a bit more
> > information to answer the question.
> >
> >j----- k-----
> >
> >On Monday 05 April 2004 05:19 pm, Rodrigo Galindez said something like:
> >>Hello list,
> >>    Recently I've been in the job of migrating a large (about 1.5GB)
> >>database build in MSSQL Server to MYSQL. The migration was done OK, I
> >>used the "SQLYog" utility to do this. The problem is that one table has
> >>image column types ... I tried to view this column types (blob data
> >>types now) but I can't in the MYSQL migrated data base, ... it just
> >>don't display anything. Any ideas ? Is there any issue problem when
> >>migrating MSSQL image column types to MYSQL ?
> >>    Thanks in advance, cheers from Argentina,

-- 
Joshua J. Kugler
Fairbanks, Alaska
Computer Consultant--Systems Designer
.--- --- ... .... ..- .-    -.- ..- --. .-.. . .-.
jkugler@stripped
ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!
Thread
MSSQL Server to MYSQL migration problemsRodrigo Galindez6 Apr
  • Re: MSSQL Server to MYSQL migration problemsJoshua J. Kugler6 Apr
    • Re: MSSQL Server to MYSQL migration problemsKaram Chand6 Apr
  • Re: MSSQL Server to MYSQL migration problemsMartijn Tonies6 Apr
Re: MSSQL Server to MYSQL migration problemsJoshua J. Kugler6 Apr
Re: MSSQL Server to MYSQL migration problemsJoshua J. Kugler6 Apr