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 .--- --- ... .... ..- .- -.- ..- --. .-.. . .-. [EMAIL PROTECTED] 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
