Subject | Optimization - Select Query |
---|---|
Author | Luis Carlos Junges |
Post date | 2009-05-05T17:19:21Z |
Hi,
How does work the optimization of select queries on firebird.
I a query that retrieve the results in 8 seconds at the first time and in 1,2 seconds after 4 times.
The problem is that after some time it requires the 8~10 seconds again. It seems that after some time the optimization table (or whatever is) is deleted.
Someone known what exactly i can do to enable it permanently or this is not possible? Or even a link with the explanation f how does it work. I could not find it.
thanks
---
Luís Carlos Dill Junges ©
"A realidade de cada lugar e de cada época é uma alucinação coletiva."
Bloom, Howard
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
[Non-text portions of this message have been removed]
How does work the optimization of select queries on firebird.
I a query that retrieve the results in 8 seconds at the first time and in 1,2 seconds after 4 times.
The problem is that after some time it requires the 8~10 seconds again. It seems that after some time the optimization table (or whatever is) is deleted.
Someone known what exactly i can do to enable it permanently or this is not possible? Or even a link with the explanation f how does it work. I could not find it.
thanks
---
Luís Carlos Dill Junges ©
"A realidade de cada lugar e de cada época é uma alucinação coletiva."
Bloom, Howard
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
[Non-text portions of this message have been removed]