Thanks all. Worked like a charm. -----Original Message----- From: Dennis McGrath <dmcgr...@qmiusa.com> To: rbase-l@rbase.com (RBASE-L Mailing List) Date: Fri, 8 Aug 2014 16:29:47 -0500 Subject: [RBASE-L] - Re: multi column change
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: rbase-l@rbase.com [mailto:rbase-l%40rbase.com] [mailto:rbase-l@rbase.com [mailto:rbase-l%40rbase.com]] 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 >
