Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two loop or not to loop?
Message
From
02/09/2004 03:27:40
 
 
To
01/09/2004 14:56:11
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00938414
Message ID:
00938659
Views:
22
Hi,

>>
I believe processing would be faster if you write to each file in turn.
Reason: the index file has to be updated for each record and more of the index could be cached.
I think the size of the tables and the .cdx is the main factor here, since the machine seems well equipped.
>>

FWIW, we've generally found it's faster to actually delete all non-required indexes before appending a large number of records then recreating them afterwards. Can't do that with a 'live' database of course...

Regards,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform