Tim,
    I couple of quick questions, that I hope I can sneak in here rather than starting a
new thread.

1) Does EDB have a better index structure that would allow for large amount of rows to be
added quicker? Say 50 million rows? I know with DbISAM it would slow down quite a bit
after the first 500,000 rows or so. I am looking for a database that had an index
structure that would allow for very large tables.

2) Does it use database locking, table locking, or row locking when adding rows?

TIA
Sam

Sam,

<< 1) Does EDB have a better index structure that would allow for large
amount of rows to be added quicker? >>

Yes.  EDB no longer keeps statistics in the indexes, making the indexes
smaller and more efficient since the entire depth of the index tree need not
be updated for inserts anymore.  In most cases, only the leaf page being
updated needs to be updated.  Only in the case of a split does any other
node require updating.

<< Say 50 million rows? >>

Well, the number by itself doesn't tell me much.  It all really depends upon
the row size, the number of indexes, etc.

<< 2) Does it use database locking, table locking, or row locking when
adding rows? >>

It uses a special table lock that allows reads but not writes during the
insert process (updating indexes, etc.) and then upgrades that lock to a
full write lock which blocks all reads and writes during the actual act of
updating the table files on disk.

--
Tim Young
Elevate Software
www.elevatesoft.com