Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tables opening slowly
Message
From
13/10/2004 08:00:52
 
 
To
13/10/2004 07:37:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00950979
Message ID:
00950991
Views:
13
I tested this directly from VFP, without any path setting.

>Are the tables in the defaut directory or in the path? Does all the >directories in the path setting really exist?

>Hi,
>
>One of our customer has a PC running windows XP. This computer is very slow in opening tables. I ran a test, one of the tables (containing just 17 records) opened in 2.20 seconds. Other tables opened faster, but still slower than expected (around 0.1 second).
>I measured the times over and over, and figures were remarkably constant (2.20 might occasionaly change to 2.19 or 2.21)
>I didn't find any reason for this in the differences between the files, so this is not caused by file size or number of deleted records.
>If Windows 2000 is installed on the same PC, everything runs fast.
>Other PCs running XP also run fast.
>The behaviour isn't related to virus scans either, since it occurs also when no virus scan is active (and virus scan would probably take at most just as long for a larger file)
>
>
>I tested a few files on a different network drive, on this drive times varied much more (between 0.00 and 0.90 for a table opening in 0.13 on the other drive).
>
>I would like to know what may cause this behaviour, and/or what happens when a file is opened. And of course how to prevent this.
>
>Regards,
>
>Auke
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform