Yes, that was the first thing i tried. The id column is indexed.
Scott Gerhardt wrote:
> 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
