Hi,

At June 4, 2005, 18:43, Svend Meyland Nicolaisen wrote:

> Wouldn't it be possible to add transaction information to the index entries
> so that the engine doesn't have to lookup the record for validation?

Basically, what you are saying is that for each record version there's
a corresponding index entry with the version information. Most likely
the search would probably be faster, but there's also a cost
associated to maintaining those index version entries. Also, it would
be most likely that you will need to keep the index entry version in
sync with the record version, and that's an additional cost. Also,
the garbage collection at the moment is performed on the record
versions, but if the indices have versions, then the garbage
collection will have to perform it's job on the indices in sync with
the record versions, because both have to be in sync to work
efficiently.

> It probably isn't possible but I was just wondering.

It might be more work than it's worth. But, to really see if there is
a performance benefit, or loss, someone will have to implement it, try
it and profile it, and compare the results with what is currently
implemented.

And, the idea can be submitted for discussion on the
Firebird-Architect@yahoogroups.com

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)