I forgot to mention something...

With the problem queries, when I open the dataset it takes 12 seconds like I say, but then if I close and re-open, it is very quick.

I don't understand...

--- In firebird-support@yahoogroups.com, "blizzardb2001" <blizzardb2001@...> wrote:
>
> 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@...
>