I've got what would be best described as a medium sized table, which
normally queries quickly, except for this one...
Table "data_static" has around 35,000 records.
This trivial query:
SELECT tracking_id,
complainant_email,
DATE_FORMAT(import_date,'%Y-%c-%e') AS date,
subject
FROM data_static
WHERE case_id = 0;
...gets explained thus:
table = data_static
type = ref
possible_keys = _case
key = _case
key_len = 8
ref = const
rows = 7126
Extra = where used
It takes just right at 60 seconds to generate 6409 result rows. Removing
the "DATE_FORMAT" calculation doesn't have any impact.
Why so slow?
One thing I thought of, but isn't trivial to change, is that one of the
fields is a "text" type that often holds near its size limit, so individual
records can be fairly large.
Is this just a matter of getting the data off the disk and to the client, or
something else?
Jim
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
