Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to have cursors never be sent to disk?
Message
From
20/01/2014 12:10:00
 
 
To
20/01/2014 12:07:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
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:
01592185
Views:
96
Have you checked the query optimization to ensure optimization is taking place?


>Hi Craig and Martina,
>
>Just ran a test with and without RamDisk for tmpfiles and sortwork and was disappointed.
>
>I am trying to optimize ExcelListener where there is a ~20MB cursor on which I run many SELECTS. Guess I have defined enough indices so that Rushmore is able to do its job well.
>
>Thanks for the answer.
>
>Alex
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