Subject Re: [firebird-support] Re: Slow query help
Author Alexandre Benson Smith
markd_mms wrote:

>wow down to 141 ms! but now searching on ITEM.TITLE by itself has gone
>up to 1.5 seconds from about 300ms showing 14010 unindexed reads on
>ITEMINFORMAT. is there a happy medium or should i just use a different
>query depending on what i'm searching for?
An important thing that I forgot to mention.

Are your indices statistics up to date ?

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil