What was the GUID stored as?

Thank-you all btw

--- In firebird-support@yahoogroups.com, "David Johnson"
<d_johnson@c...> wrote:

> 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]