Hi,

> Dear all,

> Here's another query performance question...:)
> The schema is simple: CUSTOMER, PRODUCT, SALESMAN, ORDERMASTER,
> ORDERDETAIL, with the usual relationships:

[...big snip...]

> Any comments/pointers are very much appreciated.
> Sorry for the long-winded email. Just wanted to show you how frustrated
> I am...:)

I see your frustration. When first opening a query, there's the time
for the prepare, unless you explicitly prepared the query, also
there's the loading of the data pages into the server when the query
is first executed. When running the same query immediately after the
first one, the data is already retrieved from the hard-drive. But, I
notice in one instance, it doesn't help in the execution time.

What version of Interbase or Firebird are you using?

Have you tried Firebird 1.5 beta 3? You'll probably notice a big
difference in the performance. Some are reporting differences between
20-2000% depending on the query and indices that exist in the table.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)