we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.
Software/Hardware used:
ASKED:
October 2, 2007 8:40 AM
UPDATED:
February 22, 2008 4:58 AM
Micus2005, I’m not a SQL guru but I did come across the thread below on Microsoft Forums. Although the post was about storing images in SQL, the dialog is about how to mitigate slow loads.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1540589&SiteID=1
Hopefully, a real SQL guru will come along and hit the “Create Answer” button. Good luck.
Was this information useful in resolving your issue?
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.