SELECT COUNT(*)
FROM data_static
WHERE case_id = 0;
That will give you the raw query time without the data transfer or formatting overhead.
On Wednesday, January 8, 2003, at 10:32 AM, Jim wrote:
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?
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
--------------------------------------------------------------------- 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
