Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need my queries to run faster
Message
De
28/09/2000 13:52:47
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00422174
Message ID:
00422180
Vues:
10
I am using NT on a Novell network, but all queries run locally. I have a PIII Dell machine with 128 Mb of ram with no other apps running.

What about Fox tips or tricks?

Thanks, Chris

Have you used SYS( 3054, 1 ) before your queries to determine their optimization level.
What operating System are you using?
If you are using NT 4 check out Foreground App Performance boost in System in Control Panel.
Do you have other Apps running at the same time, that could be run on a different PC or rescheduled?
Get more ram,
Get a faster CPU
Get faster hard disks (if not selecting out of a dbf on a server),
Switch from 10Mbps to 100 Mbps Network Card and Hub.
Switch from an ISA to PCI,
Switch from IDE to EIDE
Switch from EIDE to SCSI
Switch from SCSI to SCSI II
Switch from SCSI to UltraWide SCSI.
Switch from VFP to SQL Server, Oracle, DB2, etc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform