Subject RE: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test
Author Enrico Raviglione
Hi Jason,

what kind of index we must add to our database, an Index on system
tables ?
But this kind of operation are not discouraged ?
I don't remeber why but during the transition fron FireBird 1.0.x to
1.5.x i have readed that the index on the system table are lost in some
circustances, backup -> restore or some other.

Do you think to change your query and optimize it in next version of IBO
? and when ?

Best Regards.

Enrico Raviglione

IDEA Sistemi s.n.c.
Via Burolo, 30
10015 IVREA ( TO )
TEL. +39 0125 253235
FAX +39 0125 253271

> -----Original Message-----
> From:
> [] On Behalf Of Jason Wharton
> Sent: Wednesday, June 01, 2005 4:05 PM
> To: ''
> Subject: RE: [IBO] for Jason: TIBOQuery vs. TFIBDataset speed test
> I always suggest people look at the performance monitor/SQL
> trace because the query requesting that information may not
> be working optimally and the addition of an index on the
> server could greatly increase the performance if there is a
> lot of data in the system tables. Watching the SQL trace
> will reveal where the time lag is at.
> Jason Wharton