All our smartlist data returns running about 30 seconds slower in our current upgraded version, than our previous version.
Current Upgraded Setup:Remote connection through Citrix 6.5 64-bit; Dynamics GP2013; MS SQL DB 2012 64-bit (running in 32-bit compatibility mode)
Previous version:Remote connection through Citrix 5 32-bit; Dynamics GP10; MS SQL DB 2008 32-bit
That database footprint (transaction data, etc..) is the same between both previous/current.
Any ideas as to what we can check? We are working with our DBA's to make sure any indexes are not missing/dropped.
Any help is much appreciated!
Thanks for the feedback so far. The issue was we were missing indexes an the targeted tables in our new DB envrionment after we upgraded from GP10 to Gp2013.
Is this a standard Smartlist created by MS or a SmartList Builder created Smartlist?
Richard L. Whaley Author, Publisher, Consultant
Enhancing your Dynamics Knowledge!
If this statement is not in you dex.ini add it - the speed improvement is at least 30 time faster...
Read this article.
Sanjay Kumar Rajarao. ACA, MCPhttp://www.sanjaykumar.us | email@example.com
Were they custom indexes or built in indexes that did not carry over? We are having issues with smartlist performance in GP 2013 as well and are looking for anything.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics