Re: 3 million+ records problems.

2001-01-29 Thread Jeremy D. Zawodny
On Sat, Jan 27, 2001 at 09:32:56PM +0300, Artem Koutchine wrote: > Hmm.. So ID is not PRIMARY KEY (not UNIQUE index).. That makes it > harder. A lot harder. A lot depends now on how many records per ID > you have there on average. If you you have only, say, 50 ids then > you'll be slower. Basi

Re: 3 million+ records problems.

2001-01-28 Thread Colin Faber
D 3.4-Release. > > > > > > > > > > > > > > > > Artem Koutchine wrote: > > > > > > > > > Well then, be so kind and tell us your index configuration > > > > > and your hardware configuration. > > > > > >

RE: 3 million+ records problems.

2001-01-28 Thread John Jensen
es (doing RAID), running FreeBSD 3.4-Release. > > > > > > > > > > > > Artem Koutchine wrote: > > > > > > > Well then, be so kind and tell us your index configuration > > > > and your hardware configuration. > > > > > > > > - Origin

RE: 3 million+ records problems.

2001-01-27 Thread Scott Gerhardt
t; > > > > ----- Original Message - > > > From: "Manuel Capinha" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Saturday, January 27, 2001 9:10 PM > > > Subject: 3 million+ records problems. > > > > > > &g

Re: 3 million+ records problems.

2001-01-27 Thread Artem Koutchine
el Capinha" <[EMAIL PROTECTED]> To: "Artem Koutchine" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, January 27, 2001 9:27 PM Subject: Re: 3 million+ records problems. > > From a mysqldump: > > # > # Table structure for table 'names'

Re: 3 million+ records problems.

2001-01-27 Thread Manuel Capinha
To: <[EMAIL PROTECTED]> > Sent: Saturday, January 27, 2001 9:10 PM > 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 t

Re: 3 million+ records problems.

2001-01-27 Thread Artem Koutchine
Well then, be so kind and tell us your index configuration and your hardware configuration. - Original Message - From: "Manuel Capinha" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 27, 2001 9:10 PM Subject: 3 million+ records problems. >

Re: 3 million+ records problems.

2001-01-27 Thread Manuel Capinha
MAIL 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

RE: 3 million+ records problems.

2001-01-27 Thread Scott Gerhardt
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 problems.

2001-01-27 Thread Manuel Capinha
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