Hi guys...

I can't understand this. A procedure to open a query in my application is taking about 12 seconds. I have done a lot of tests and if I do a simple query of
SELECT "ID" FROM "TblFlightSchedule"
or
SELECT "ID" FROM "TblFlightBookings"
I have to wait about 11 seconds, where as a simple query of
SELECT "ID" FROM "TblBookings"
takes about 1.5 seconds.
I tried adding an index on the problem tables, but they only have about 20 records.

The only thing I can think of is that these problem tables are 'dependencies' of a stored procedure. But I think these 'dependancies' are simply from IB Expert - they are automatically "created" when your stored procedure mentions a table.

I am happy to provide you with the login details for the server (by email) if you want to have a look around - maybe you can tinker with something and fix it :)

Here's my email address: rfwoolf@...