Re: Lots of EOs slow down the performance
Re: Lots of EOs slow down the performance
- Subject: Re: Lots of EOs slow down the performance
- From: Guido Neitzer <email@hidden>
- Date: Thu, 6 Nov 2008 10:59:49 -0700
On 06.11.2008, at 10:49, Chuck Hill wrote:
Another speedup (depending on the database, I'd never use that with
FrontBase again): use EOF 24 Byte binary primary keys.
Not with FrontBase? I think that is what Geert recommends, at least
if you want to do clustering / replication.
I don't know whether they have made indexing these beasts faster, we
(old company, not at ClickSpace where we use PostgreSQL) had some
issues on G5 hardware that it just got slower and slower and slower to
insert into history and log tables (with some ten million rows in
them). Changing it to integer pks made it noticably faster (after one
hell of a conversion, because that one took FOREVER).
I'd use them nevertheless, but at least FrontBase 4.2.8 wasn't the
fastest indexing big tables on binary or string columns and that
seemed to have caused the problem. So, just be aware of it if you
insert into high volume tables (history or log tables) with EOF keys.
cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden