Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only