Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sudden slow database access
Message
De
18/01/2015 22:42:16
 
 
À
17/01/2015 16:51:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01613560
Message ID:
01613852
Vues:
57
Hi All, Thanks for all the help and tips. I have been testing some more and can conclude:

I am NOT 100% sure this problem started 12/31. I just get too many conflicting reports. Because of that and because the network persons have ensured me they can NOT find anything that changed 12/31 and because we have turned off virus checking on the server and the workstations, I want to stick with the following test:

I have tested a bunch with up to 4 workstations. I even tested using the new server (2008 R2) as a workstation. The results are always the same.

In the following tests it really does not matter but the "Get Records = 15 seconds" should be considered perfect meaning great meaning we would not be having this discussion.

All users out of my app.
User 1 logs into my app.
User 1 does Get Records = 15 seconds.
User 2 logs into my app.
User 1 does Get Records = 2 1/2 minutes.
User 2 does Get Records = 2 1/2 minutes
User 2 logs out of my app leaving only User 1 logged into my app.
User 1 does Get Records = still 2 1/2 minutes.
User 1 logs out of my app. At this point no users are in my app.
User 1 logs into my app (at this point User 1 is the only user).
User 1 does Get Records = 15 seconds.

Summary: As long as there is only 1 user in my app, all if good. As soon as a 2nd user logs into my app, both users are adversely effected. Having the 2nd user log out of my app does not put User1 back to being fast. Once 2 users have entered my app it becomes slow and will continue being slow until all users log out and only 1 user logs back in.

I did the above with 2 workstations then reversed it, same results.
I did the above with 2 completely different workstations, same results.
I did the above with 1 of the above workstations and using a 3rd workstation as the 2nd user, same results.

I can run my app on the server. In the above test I tried running my app on the server as the 2nd user, same results.

I have a program that runs on the server 24/7 that also opens my app's database. This program was NOT running in any of the above tests.
This program has no user interface. It does batch type processing, ftp'ing, etc. When that program is running on the server and using it as the 2nd user in the same test, same results.

So again, my app functions great (Get Records = 15 seconds), as long as there is only 1 user. Surely this is NOT normal VFP behavior or is it? I have been coding FoxPro for 25 years and have never known of this. It sounds like some of you may be trying to tell me, Yes, if 2 or more users have your database open and even if only 1 of those users is querying the database, it could be 4 times slower for the user that does query the database. Is this possible?

One more thing. My app IS slow. I have been working toward a move to TSQL for at least 2 years (and a 100K dollars), but am still months away from converting the 1st installation. The system has 100 tables and almost 1000 views. I do have one more test to conduct. I am now afraid this may be effecting my app at all my customer sites and that I am just unaware of it and because my users know the app is slow they are just putting up with it. I will conduct that test hopefully by tomorrow and will post results.

Thanks all,
John
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform