On 6 Oct 2002 at 12:00, Thomas O'Dowd wrote:
> transaction = [ 3 x inserts, 2 x simple selects ] x 100
> job = 1000 x transactions.
> Firstly why does this slow down so much from the first couple of
> commits? Secondly, what are the tuning options that affect this kind of
> thing if any?
Try analyse tablename after each transaction.. May speed up the things..
HTH
Bye
Shridhar
--
No problem is insoluble. -- Dr. Janet Wallace, "The Deadly Years", stardate
3479.4