>Luc,
>
>I would stop focusing on hardware. You might squeeze a few percent more performance out of it, but you can get much and much more performance gains (up to 10.000% and more) when you look at your application. Identify slow parts and try to tune them.
>Are there slow queries? If so, try to rune them by adding or tuning indexes. You might want to redesign queries to run faster.
>
>Walter,
I'm not complaining about the speed of the ERP software. It is running nicely.
I was just surprised that after moving the virtual machine from a 5 year old server with less memory to a new server with all the top notch hardware improvement and 64Gig of memory the gain in performance was not that significant.
This means that the 4Gig limit was already obtained on the previous server and adding more memory had no effect on the application on the new server.
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)