Christian Paul B. Cosinas wrote:
Hi To all those who replied. Thank You.
I monitor my database server a while ago and found out that memory is used
extensively when I am fetching records from the database. I use the command
"fetch all" in my VB Code and put it in a recordset.Also in this command the
CPU utilization is used extensively.
Is there something wrong with my code or is it just the way postgresql is
behaving which I cannot do something about it?
I just monitor one workstation connecting to the database server and it is
already eating up about 20 % of the CPU of database server.
Which I think will not be applicable to our system since we have a target of
25 PC connecting to the database server most of the time.
Could you post the query and the output of EXPLAIN ANALYZE?
In addition, have you run ANALYZE on all the tables in that database ?
(sorry, have to ask :-) ....).
cheers
Mark
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly