Hi!
I've got a table with 3 million+ records. This table has only to
columns: an int and a varchar(80).
I need to periodically execute a statement like: "SELECT id,count(*)
FROM names GROUP bY id", which takes very long time to end.
I'm using perl (DBI) to access this table. When I do a select by id
(SELECT name FROM names WHERE id=1) it hangs forever for very large
results (>1million).
I'm running mysql 3.22.29 on FreeBSD 3.4. Would an upgrade to the latest
3.23 help ? Would an upgrade to FreeBSD 4 or maybe Linux help ?
The id column is indexed, but i believe this is A Good Thing(tm).
I've checked past messages of this mailing list and i couldn't find
anything that seemed relevant to my case. Can anyone give me some
suggestions to speed things up ?
Thanks in advance.
Manuel Capinha,
who as just seen his weekend ruined.
---------------------------------------------------------------------
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