Quote Originally Posted by Anders Ohrt View Post
We've started looking at migrating from Pervasive to MSSQL, and with the default settings it's a noticeable performance drop. So those of you that use MSSQL today, what settings have you had to tweak to improve performance for your applications?
Use CCH files to get the application to start faster.
Use esql a lot. Using esql we have got our application to be a lot faster than pervasive ever was.
But you need to find the best places for it. Start with Big loops and replace them with esql and you will see a big performance boost.