I had to laugh, when I posted the above comment and then visited the general forum active topics the one right below this topics was
Nav 4.0 SP2 runs slow on SQL Server 2000 SP4 ,
Of course it does, and with a lot of tuning and programming, and maybe highering a skilled SQL administrator, he will be able to get a system that runs as well as our original 2.0 native database did, back in 1999. of which we had to do nothing to keep it running that well over the following 6 years. but Now in 4.0, we need to keep on top of everything to keep it running well
We killed our Maintenance after one year.
We do everything ion house now and Upgrading any further is not going to happen.
"If it ain't broke, don't fix it" is the bosses motto.
We'll probably run this version for 5 years or more before looking at a new one.