Now one of my client using NAVSQL database,firstly they were using Native database,now there speed is too slow then earlier.what can I do to increase their speed???????????????
There are a number of issues e.g. hardware setup, SQL setup and SQL performance. I would recemmend that you get someone with SQL experience involved as this is not a simple fix. There are two sections on Mibuso that deal with issues like this SQL Performance and SQL General - have a read through them.
Comments
Then post more focused questions as you have them. Also your system details would be helpful.
There are a number of issues e.g. hardware setup, SQL setup and SQL performance. I would recemmend that you get someone with SQL experience involved as this is not a simple fix. There are two sections on Mibuso that deal with issues like this SQL Performance and SQL General - have a read through them.
Dynamics Nav Add-ons
http://www.simplydynamics.ie/Addons.html