Brilliant, Dennis. I've split the file at that point for years into .str
and .ind - but your way is more elegant.
Albert
On 8/8/2014 11:25 AM, Dennis McGrath wrote:
Nice description Razzak,
To really speed things up on a large database (since loading data after the
indexes exist is a lot slower)
1. Add "RUN dbname_data.dat" in the dbname_structure.str file just before the
first CREATE INDEX statement
2. Now RUN dbname_structure.str and the whole process will complete in record
time.
Best Regards,
Dennis McGrath
