Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Time to close large tables?
Message
From
23/01/1999 11:51:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Time to close large tables?
Miscellaneous
Thread ID:
00179393
Message ID:
00179393
Views:
42
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.
Next
Reply
Map
View

Click here to load this message in the networking platform