Re: question on logical log

Stephane Magnan wrote: > > Hi, > > This week-end, we have to load data in a database. > > I would like to know if we will meet a problem with long transaction. > > We want use the sql statment 'load from filename ....' > > Could you tell me if this command execute sometimes 'commit' or it > commit at the end of loading. > > Stephane In isql, it would be all or nothing. Don't forget to lock the table if it's a big load, so you don't run out of locks. Whether you get a long transaction depends on your load file and online settings and sytem. If you want to load and save as you go, use the dbload command and you can specify to commit after every n rows. If if died, you could then do another dbload skipping the first n rows that were previously committed. There are other solutions as well. Like reading the file with some calls to c and doing your own load. This all depends on what level of commit/rollback you want, etc. Tim