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:
00557256
Vues:
14
Were on a Novell network and each workstation has their own anti-virus software running (Norton, McAfee, etc.) and I don't know what the file server has.

I'll try your suggestion, thanks.

Arriyel

>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
Speak using soft and sweet words in case you have to eat them later.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform