I am testing a Linux Progress version 8.3B22 on a Intel SUSE 6.3 Server with 128Mb Memory.
I have a database (1.5 Giga) service running on it.
I have noticed 2 things:
1) The CPU-Usage is very high (98%).
2) A performance test programm, with a for each and several finds statements over large tables, takes 4 times as long using the connection to the Linux-Service as compared to a connection to the NT-Service running the same database.
How can reduce the CPU-Usage ?
How can I optimize the connection to the Linux database?
Thank you
I have a database (1.5 Giga) service running on it.
I have noticed 2 things:
1) The CPU-Usage is very high (98%).
2) A performance test programm, with a for each and several finds statements over large tables, takes 4 times as long using the connection to the Linux-Service as compared to a connection to the NT-Service running the same database.
How can reduce the CPU-Usage ?
How can I optimize the connection to the Linux database?
Thank you