Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Daniel,
>> After some experimenting on a WAN network I discovered that opening lot's of tables resulted in very poor performance. It seemed to be that small tables ( smaller than a few kb) loaded faster (with either the USE statement as loading with the dataenvironment) than longer tables
>One common problem is anti-virus software that automatically scans a table whenever it's opened.
This is not the case. I never install anti virus checking software on my machine. Besides, I think this is default behaviour. On a LAN you won't notice the buffering much because it only buffers a small part of the table and the bandwith of the LAN allows fast downloading of those buffers. OTOH if you're on a WAN downloading buffers do take quite some time. I've noticed that small tables load significantly faster than larger tables. Since VFP will only buffer a few KB some small tables will be buffered entirely, others will be buffered for only a small portion (larger).
If there is some way to control the size of the buffer, we will be able to control the performance of opening tables. Especially when using slower networks (10 mb or slower) you can reach better performance because less data has to be downloaded from the network.
Walter,
Précédent
Suivant
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