General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only