Subject | RE: [firebird-support] Re: Speed issues |
---|---|
Author | |
Post date | 2015-02-07T19:28:06Z |
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
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