Your keys are too large and have the same leading characters. Since the first hundred characters are the same you waste a lot of CPU time in comparisons.
Try to get your total key size down to a fraction of that size. At least change your program to generate keys of this form instead and it will be much faster: key = ptr + key; --- RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > for(int j=0; j<100000;j++) > { > char* ptr = tmpnam(0); > string key = > "111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111."; > key += ptr; > fout1<<key<<endl; > fout<<"insert into test values > ('"<<key<<"',"<<"'22222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222');"<<endl; > > } ____________________________________________________________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. http://farechase.yahoo.com/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------