Have you tried adding an index on id?
> -----Original Message-----
> From: taree [mailto:taree]On Behalf Of Manuel Capinha
> Sent: January 27, 2001 12:10 PM
> To: [EMAIL PROTECTED]
> Subject: 3 million+ records problems.
>
>
> 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
>
>
---------------------------------------------------------------------
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
