Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to have cursors never be sent to disk?
Message
De
20/01/2014 12:10:00
 
 
À
20/01/2014 12:07:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01592171
Message ID:
01592185
Vues:
98
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform