List:General Discussion« Previous MessageNext Message »
From:duo fu Date:August 12 2002 1:59am
Subject:Query problem/mysql
View as plain text  
Hi, friends:

I have just created a small web site with php/mysql. I do a query into one 
of my tables whose ".MYI=338K " and ".MYD=7.6M". I could only retrieve some 
part of the data and then the browser just died there.
My query is " select * from Forces". The primary key is combination of 
several fields. Table Force has 132 fields. Its size reaches 20 MB.
How can I solve the problem? Will adding an index help? I am just intending 
to print out the whole table.

Could you please help me out?
Thank you very much!


MSN Photos is the easiest way to share and print your photos:

Query problem/mysqlduo fu12 Aug
  • Re: Query problem/mysqlDan Nelson12 Aug