Subject RE: [firebird-support] Re: Speed issues
Author
Sean,

I dont have other connections to database - I am runing it on my development machine. timing for the second run never was a problem - second query with same params is exretmly fast. Problem is that I dont have 2 same params never one after first. And, whenever I change params, first query is relatively slow.

regarding header stats

Oldest transaction    2020
Oldest active            2021
Oldest snapshot       2021
Next transaction       2035

I have 8 gb of Ram. db size is about 26 GB.    
Page size of database is 4096.    
Index stats  of LINK_LA_TYP_IDX5 is 0.000000105665.
Selectivity of the fields in link_la_typ is:
lat_ga_id = 2470 / 125.000.000
lat_la_id = 17.500.000 / 125.000.000

it seems that I cant do it much faster, altough I tought it is possible after changing parameter in where clause.
Regards,

Zoran