Re: PUT cursor very very very slow ... but it works with no error ! WHY ?

"Art S. Kagel" a écrit : > Two independent problems. First because you are constantly inserting and deleting > > rows in this table the stats for it are likely almost always out of date. You > need to run > update stats on the table immediately before the update app and immediately after > and it probably could not hurt to run it from within the app at around the halfway > > mark in the processing. > > Second I see major tuning problems. Read on: > I wish to thank you both for your help. I've adjusted LRUS, BUFFERS, NUMAIOVPS, PHYSFILE, SHMVIRTSIZE and even LOCKS and it seems to work much better. There's no more "freezing" statements but only some days of real work will reassure me definitely. If I encounter such troubles again, upgrading seems to be the solution or perhaps NOLRUPRIO. I forgot to say that we run 2 instances of IDS 7.30 on this box (in fact we have installed IDS 2 times and I hope they are totally independant from each other). Apparently your advises are working well and there's no interraction between them. Wait and see... Last thing as far as backups are concerned: If we do not make neither archive nor logical log backups, it's only because we archive the DBEXPORTed databases every night and, as they're 2 IDS, we would need (at least) 2 tape drives for a continuus log backup. Another explanation is that dbexport is loadable anywhere else if the hardware crashes. Of course it takes time (but night is long) and can't be done online but it's a good way to make every user release their connections at least once a day ... and we don't know how to reload a particular set of tables in case they need it ... 2 ou 3 days after having made a mistake ! Managing small databases have his advantages ...