Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
My application got slow!
Message
 
To
01/08/2001 16:16:50
David Foulkes
Probusiness Systems, Inc.
Cedar Park, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00538488
Message ID:
00538691
Views:
8
David,

Thank you for the response.
Today I have been on my customer's site in order to verify his problem more closely. I got some facts I would like to share with you all:

- The slowness problem was sporadic. Sometimes the application simply halted without any visible or detectable motive.
- There were no anti-virus software running on the server.
- I have detected that some slow parts were related to points of the application where a number of DBF files were open; so I decided to verify these files...
- I tried to USE all files that the application was trying to open and here I found a REALLY STRANGE situation...
- Three tables of my aplication took minutes to be open (about 2/3 minutes through a USE [tablename] instruction). All three tables were very small and one of them had no records at all.
- I did all these tests on the server in order to discard possible network latencies or issues.

Now my doubt is: How can possibly a table with no records with a DBF of about 5 KB and a CDX even smaller can take so much time to be opened?

Thanks!
-----
Fabio Vazquez
http://www.fabiovazquez.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform