Open statement
Posted: Thu 26 Jun 2014 10:32
Hello
I am trying to improve the performance of a SELECT statement in PGQuery. In addition to set the correct DB indexes, to reduce the number of data to retrieve, what other general advices would you give ? I know this is a very general question but I am just looking for general guidelines.
I have also noticed that setting PGQuery.Prepare= false improves the performance.
Many thanks
Pio Pio
I am trying to improve the performance of a SELECT statement in PGQuery. In addition to set the correct DB indexes, to reduce the number of data to retrieve, what other general advices would you give ? I know this is a very general question but I am just looking for general guidelines.
I have also noticed that setting PGQuery.Prepare= false improves the performance.
Many thanks
Pio Pio