Hello
I have a problem with a customer that uses the application developed by us in Progress.
The system performs extremely slowly even though the hardware power literally strong enough.
This is one of the most powerful configurations we have and they have an extremely poor performance.
The hardware/software configuration is:
The Server:
Fujitsu Siemens PrimePower 400
2 x SPARC 64 500 MHz CPUs
2GB RAM
RAID 7 Disk Storage accessible through 1GB FiberCat 4500
1GB LAN Card
Sun0S 64 bit OS version 8
Progress:
Server – Enterprise DB version 9.1D06
Client – Client Networking version 9.1D06, Actuate Reporting system.
The real size of the database is 2.4GB.
Number of users: 80
The problem is that the application is running very slowly.
He test a select count (*) from a table and the database only cans rich to the 30.000 reads per second with only a user in the machine.
When we increase the number of users, the number of records reads stays the same.
The writes never passed from the 100 records per second.
Another problem is that if we change the configuration (-B, -Ma, etc.) everything seams never to produce nothing in the performance, even we split the data from the indexes but the performance stays the same, the customer says that the performance is the same.
The people from the company who install the network, does a check and they say that the network is fine.
The application is the same we have in another costumer, the same configuration (clients windows and server unix, solaris or linux) the only different is the configuration of the machine.
The fragmentation of the database is ok because we recently made Dump/Load.
Did somebody help me, because this problem started one year ago, and the people from Fujitsu Siemens analyses the machine and they change some configuration but the performance stays the same.
Nobody knows what to do more to solve this problem.
I have a problem with a customer that uses the application developed by us in Progress.
The system performs extremely slowly even though the hardware power literally strong enough.
This is one of the most powerful configurations we have and they have an extremely poor performance.
The hardware/software configuration is:
The Server:
Fujitsu Siemens PrimePower 400
2 x SPARC 64 500 MHz CPUs
2GB RAM
RAID 7 Disk Storage accessible through 1GB FiberCat 4500
1GB LAN Card
Sun0S 64 bit OS version 8
Progress:
Server – Enterprise DB version 9.1D06
Client – Client Networking version 9.1D06, Actuate Reporting system.
The real size of the database is 2.4GB.
Number of users: 80
The problem is that the application is running very slowly.
He test a select count (*) from a table and the database only cans rich to the 30.000 reads per second with only a user in the machine.
When we increase the number of users, the number of records reads stays the same.
The writes never passed from the 100 records per second.
Another problem is that if we change the configuration (-B, -Ma, etc.) everything seams never to produce nothing in the performance, even we split the data from the indexes but the performance stays the same, the customer says that the performance is the same.
The people from the company who install the network, does a check and they say that the network is fine.
The application is the same we have in another costumer, the same configuration (clients windows and server unix, solaris or linux) the only different is the configuration of the machine.
The fragmentation of the database is ok because we recently made Dump/Load.
Did somebody help me, because this problem started one year ago, and the people from Fujitsu Siemens analyses the machine and they change some configuration but the performance stays the same.
Nobody knows what to do more to solve this problem.