in reply to How can I improve the sql statements applying efficiency

It's sometimes possible to rewrite such files into bulk load format for the bulk utility of the database (bcp, in the case of sybase). (Such bulk loading is typically much faster then executing sql statements.)

update: Nevermind, I see roboticus already mentioned this...

  • Comment on Re: How can I improve the sql statements applying efficiency