Last post Sep 29, 2010 01:08 AM by ignatandrei
Sep 28, 2010 04:24 PM|joel_john|LINK
I am developing an application for queries and reporting. The problem is that access to data is through an old database fox pro, via the network, the system still works
for the company, the application is for queries and reports that will be available on the Local network.
I wonder if I can increase performance if I copy the database locally before starting the day or in a specific time of day, to make access faster and if you need to update the data then you would copy it again.
As I say, is only for reports that do not require that the information is at the last minute.
Some queries take longer to be executed.
What you will do? of course, Better would be a new systems jejej, but they won't.
SQL SERVER 2005
Sep 29, 2010 01:08 AM|ignatandrei|LINK
I can increase performance if I copy the database locally before starting the day or in a specific time of day
try it on a local PC. (obviously, if server hard disk read speed + network transfer speed > local hard disk read speed , it will not be an improvement)