On an 800 MHz Win98 box with 512M RAM, FB 1.5 RC8 I was able to return 152 rows per second on a 4 million record table using GUID as priimary key.

----- Original Message -----
From: David Johnson
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 02, 2004 7:31 AM
Subject: Re: [firebird-support] GUID as Primary Key


I would be very concerned if it is taking 6 seconds to search only a million records. I don't have a solution and have to go.
----- Original Message -----
From: Luke Young
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 02, 2004 1:01 AM
Subject: [firebird-support] GUID as Primary Key


Can anyone give some guidence?

I want to use a GUID as the primary key in my data tables. The project
is in its early stages and I have been using a VarChar to store the GUID.

As part of the feasibility testing I inserted one million records into
a table. A simple SELECT query took 6 seconds to return a result, very
impressive, considering it was done on a 2100+ AMD with 512 MB.

But...

My question: Is there a more efficient way that I can use GUID's. I
have read on this list people achieving sub 1 second transactions.

Thank-you In Advance

Luke



------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]