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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
