Thanks, Albert I never thought of doing it that way either until I read Razzak's message and it triggered an AHA! moment.
Dennis -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Friday, August 08, 2014 4:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: multi column change 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 >
