Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow Table opens
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00556666
Message ID:
00556960
Vues:
15
There where earlier threads about the same problem on Win2K network and it was traced down to anti-virus sowtware. Try to turn ant-virus off and see if it helps.

>Hi,
>
>Finally traced slowdown in our VFP6 multi-user app that takes it over 2 minutes to get to the login screen. It was in the program that opens and sets up tables, cursors and local views.
>
>The slowdown only happens for all subsequent logins after the first. Anyone who logs in first takes less than 10 seconds but everybody else takes over 2 minutes.
>
>I've set start and end times for each open and setup of each table/cursor/local view and it takes each about 3 to 4 seconds to complete. With over 30 tables/cursors/local views to open and setup, that converts to 90 to 120 seconds.
>
>Most of the tables have less than 100 records and I only do the following:
>SELECT 0
>USE MyTable
>SET ORDER TO MyOrder
>
>Anyone knows what's going on? I'd appreciate any help on this. TIA.
>
>Arriyel
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform