Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to have cursors never be sent to disk?
Message
De
23/01/2014 15:05:02
Craig Berntson
Quicken Loans
Salt Lake City, Utah, États-Unis
 
 
À
23/01/2014 14:04:46
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: How to have cursors never be sent to disk?
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:
01592349
Vues:
85
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform