Hi,

At July 3, 2003, 05:20, Rhett Rodewald wrote:

> I understand why 1.5 is so much faster, what I want to know is, "Can
> I speed up 1.0 similarly?"

You might not see the same performance improvements. The reason being
is that it's not the only performance improvement in FB 1.5. Let me
name a few improvements other than the indexes on the system tables:
improved optimizer for data retrieval, sort files uses physical RAM
before HD, tweakable thread scheduler(so that a long running query
will not slow down another connection), improved memory management,
short-circuit boolean evaluations of the WHERE clause conditions(FB
1.0 and Interbase does a full boolean evaluation).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)