In Java, assuming you have a Connection c, you simply say "c.commit();" after doing some action on the database. After every commit, the transaction will be executed and closed and a new one opened, which runs until the next commit.
Regards, Frank. On Fri, 29 Dec 2006 13:23:37 -0500 James Neff <[EMAIL PROTECTED]> thought long, then sat down and wrote: > I'm sorry to ask a stupid question, but how do I 'commit' the transactions? > > Thanks, > James > > > > Frank Finner wrote: > > When do you commit these inserts? I occasionally found similiar problems, > > when I do heavy inserting/updating within one single transaction. First all > > runs fast, after some time everything slows down. If I commit the inserts > > every some 1000 rows (large rows, small engine), this phenomenon does not > > occur. Maybe some buffer chokes if the transaction ist too big. > > > > In your case I'd recommend to commit after every one or two million rows > > (if possible). > > > > Regards, Frank. > > > > > > On Fri, 29 Dec 2006 12:39:03 -0500 James Neff <[EMAIL PROTECTED]> thought > > long, then sat down and wrote: > > > > > >> Greetings, > >> > >> Ive got a java application I am reading data from a flat file and > >> inserting it into a table. The first 2 million rows (each file > >> contained about 1 million lines) went pretty fast. Less than 40 mins to > >> insert into the database. > >> > >> After that the insert speed is slow. I think I may be able to type the > >> data faster than what is being done by the java application on the third > >> file. > >> > > > > > > > -- > > James Neff > Technology Specialist > > Tethys Health Ventures > 4 North Park Drive, Suite 203 > Hunt Valley, MD 21030 > > office: 410.771.0692 x103 > cell: 443.865.7874 > > -- Frank Finner Invenius - Lösungen mit Linux Köpfchenstraße 36 57072 Siegen Telefon: 0271 231 8606 Mail: [EMAIL PROTECTED] Telefax: 0271 231 8608 Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
pgpDrKhdO6LeK.pgp
Description: PGP signature
