Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Tommy;
I have some apps with VFP Databases with tables of over 1 Gig and they run queries with acceptable speed. Gee – that sounds subjective – but the client does not complain, which determines the success of any project. I will presume you have done everything to optimize your code. Do you recycle used records? Do you use a Deleted() Tag, etc.?
As for the server, how active is it? Have you monitored activity? How fast are the hard disks and how large? How much RAM? Speed of your network? Most important – how big are the average data sets your queries are returning?
Your system might just require a bit of fine tuning. Could you give an example of time to complete a typical query and the size of the dataset?
Tom
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement