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.
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
Computer Consultant--Systems Designer
.--- --- ... .... ..- .- -.- ..- --. .-.. . .-.
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!