Graeme Geldenhuys wrote: > Op 2010-06-30 16:55, Lee Jenkins het geskryf: >> Graeme? I know you're using FB and GUID's. > > We have a considerable amount of data, and have not noticed any visible > speed issues with using GUID PK's in Firebird. Then again, we don't just > pull back 1 million records simply to find one record. We query only for > what we need - which greatly improves performance. And we use hard-coded > visitor of course. The benefits of GUID's also far outweigh the cons of > using other PK's types. > > I think today's databases are intelligent enough to correctly handle any > types of data (even if it is used for the PK or part of the PK). > > PS: > Where in CodeGear (aren't they called Embarcadero now) is this PK & GUID's > discussion - I'd like to read what they say. Just curious. > >
Graeme, embarcadero.public.delphi.database.general "Primary Key - integer or varchar" -- Warm Regards, Lee ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ tiOPF-talk mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/tiopf-talk
