Forum Post: What is the best configuration for OE 10.2B Database?

Status
Not open for further replies.
B

bluelinebrotha

Guest
Hello, I have a client that is running an OpenEdge RDBMS backend with a database. The software is a POS system that links to that database and uses OpenEdge as an engine. They run Windows Server 2008 with 32GB Ram and a 1TB drive. Speed and space do not seem to be the issue for this customer. He claims that when finalizing a transaction iun the POS system, there is a 30 second or so lag that occurs about 90% of the time on each of his workstations (Note that a full network diagnostic, router replacement, and rewiring was recently done and that did not fix the issue). I immediately think that this might be a problem with how the OE database was initially setup in OE Explorer. Perhaps there are not enough users/servers or the ratio's are all wrong. This server is a powerhouse so the lag might be coming from setup. I can post information on the servers configuration, but wanted to see what the idea setup is and what I could do to reduce lag and maintain database efficiency? Thanks

Continue reading...
 
Status
Not open for further replies.
Top