Re: very long query time

[Brent Baisley]

Part of the problem may be the size of the returned set. If you are 
having MySQL return the date on 11K rows, your bottleneck may be the 
network or disk. Remeber, MySQL has to read all that data from the 
database and transfer to your program or display it for the command 
line. Even if you had a database of only 11500 records, you still can't 
get by the time require to transfer that amount of data.

If you don't need all the data at once, you definitely should use the 
LIMIT clause.

On Friday, June 27, 2003, at 05:34 AM, Maurice Coyle wrote:

hi all,
i have a table in my mysql database with around 66 million rows in 
it.  when i query this table, it takes anywhere from 3 minutes to 10 
minutes to return the results.  i've tried this both from within the 
mysql command line and from java programs.
 
Section 1.2.4 in the manual says the maximum table size is 4Gb and 
when i use the show status command for this table, it says the 
data_length is 1,585,947,820 and the max_data_length is 
4,294,967,295, so the table size seems to be well within the limit.
 
The results for a query to this table can contain up to 11500 hits, so 
maybe this is the problem?  If there's no fix for this, does anyone 
know how i can query for only the top 100 results, say?
 
i can't see what's wrong, can anyone shed some light on this 
problem/offer the benefit of your experience in similar matters? i'd 
really appreciate it if you could.
 
thanks,
maurice


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]