J
James Palmer
Guest
This is purely my opinion, but I would never connect a user session shared memory. If they crash holding a lock then there's a good chance they will bring the databases down as well. It's just not worth the risk. We have clients who have a number of RDS servers load balanced to connect to the databases over the network. Our largest customer has around 120 users on 4 RDS servers. They have no problems at all with performance on the Progress side. They have some performance issues because they cut costs in terms of hardware, particularly disk, but in terms of the application itself it doesn't bat an eyelid with that many users. If you're experiencing performance problems, it's important to isolate the causes. There's no point tuning the database if the network is the bottleneck. There's definitely no point tuning the database if code is the problem. There's a very good session on Friday at EMEA PUG Challenge ( www.pugchallenge.eu/.../program-details ) if you're interested in improving the performance of your application, and working out what the bottlenecks are. In fact there's probably a lot of content that will be relevant, but be quick, it's only 2 weeks away!
Continue reading...
Continue reading...