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 <jneff@xxxxxxxxxxxxxxxx> 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 <jneff@xxxxxxxxxxxxxxxx> 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: frank.finner@xxxxxxxxxxx Telefax: 0271 231 8608 Web: http://www.invenius.de Key fingerprint = 90DF FF40 582E 6D6B BADF 6E6A A74E 67E4 E788 2651
Attachment:
pgpEQYr5m1hey.pgp
Description: PGP signature
