Re: Performance problems after suspending logging

Andres Maehlmann wrote: > > Greetings, > > we observed a dramatic performance decrease when > loading a table (load from file...) since we > stopped logging with > > ontape -N> > (OWS 7.2, Sinix 5.43) > We had to suspend logging because the logical log > files became full due to a long transaction. > (the load file being aprox. 1 MB) > > Could someone comment on the nature of this problem, please? > How many logical logs do you have and what is their size ? 1 MB is not so much ... If load into non logged DB is too slow, look at loaded table scheme, whether it has cluster index - this would require moving all table after every loaded row - and this also be why long transaction appeared. There is utility dbload in version 5 - you can load very large tables to logged database and commit work after a number of rows -> no long transactions. I suppose there is something like this in v. 7. Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------