On Mon, Jul 27, 2009 at 3:06 AM, Developerdev...@pas-world.com wrote:
Hello,
I am trying to optimize the count of files when I am using filters
(select by some row/s parameter/s)
In this case I think that postgresql really count all files.
Resulting in unacceptable times of 4 seconds in
Developer wrote:
Hello,
I am trying to optimize the count of files when I am using filters
(select by some row/s parameter/s)
In this case I think that postgresql really count all files.
Resulting in unacceptable times of 4 seconds in http server response.
Triggers+store in this case do not
On Mon, Jul 27, 2009 at 5:06 AM, Developerdev...@pas-world.com wrote:
Hello,
I am trying to optimize the count of files when I am using filters
(select by some row/s parameter/s)
My question is:
Any method for indirect count like ordered indexes + quadratic count?
Any module?
Any
How up to date do the counts need to be? If the count takes 4
seconds, can you run it every minute and store the counts in a table for
retrieval by the HTTP requests?
Now, I am storing integer value for filter in memory with timeout, but
in busy server, system sure crash without system