> 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.

Did you try these queries from IBExpert? What statistic it showed?
Did you try isql? How remote is your remote server?
So far my best guess is that your server is extremely remote, and
your application is extremely bad.

SY, SD.