Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Time to close large tables?
Message
De
23/01/1999 11:51:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Time to close large tables?
Divers
Thread ID:
00179393
Message ID:
00179393
Vues:
43
Hola All!

I'm running VFP 6 on a Dell 450, 128M Ram, 10 Gig Hard drive, running NT 4.0, sp 3. I've noticed, from time to time, when I am
closing down large tables. ( > 1 Million recs), the time it takes to close can stretch into 35 or 40 seconds. The whole time, VFP comes up as "Not Responding" on the NT Process Manager.

These tables are stored on a RAID 5 tower on a Windows NT server. I don't have delays that are nearly noticable when opening all of these tables.

I Close down the tables with a simple, "Close Databases" in the destroy event of my formset. Nothing fancy.

Has anyone else noticed these large lag times? Is there something I can do differently?

Thanks in advance.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform