If you have SQL Server 2008. You should enable the option ‘Optimize For Ad Hoc Workloads’ If you have SQL Server 2005. You should enable the option ‘Forced Parameterization’

From the ground up, Ollie has been designed for Users. A User in Ollie, is simply a Contact in SAFE which has been linked to a Customer. By default, everything in Ollie is based on the User seeing only information he/she is supposed to see. Products, Orders, Reports are all limited in this way. So… Read more.