Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tables opening slowly
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00950979
Message ID:
00951038
Views:
9
You say there is no virus scanner running - is that local? What about the server? You seem to have narrowed it down to a particular server and that machine. Can you move the machine to a different physical network connection and experience the same results? What about another computer with similar settings connected to that network plug? Have you tried replacing the network card? What about RAM in that machine - can you swap it out with some from another machine that works?

>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform