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.
nd 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.
Hi!
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
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
FreeBSD 3.4-Release.
Artem Koutchine wrote:
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:
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.
Hi!