Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to have cursors never be sent to disk?
Message
From
23/01/2014 15:05:02
Craig Berntson
Quicken Loans
Salt Lake City, Utah, United States
 
 
To
23/01/2014 14:04:46
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: How to have cursors never be sent to disk?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01592171
Message ID:
01592349
Views:
69
Moving to SQL Server to increase query speed rarely results in improved speed.


>The other option is to put the 20MB file on SQL Server and have SQL Server provide results to the users. SQL will use multiple cores and all the RAM to evaluate queries. If you parameterize your queries, SQL will reuse query plans.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform