Re: performance problem with oracle dbd


Clear questions and runnable code get the best and fastest answer
	PerlMonks

by pizza_milkshake (Monk)

on Apr 15, 2004 at 23:43 UTC ( [id://345586]=note: print w/replies, xml )

Need Help??

i do not have alot of experience with oracle, but i've been dealing with insert issues in other databases lately. here's some things you can try:

see if oracle comes with a tool that will import csv/tab-sep data. this is often many times faster that putting it into sql and inserting it.
check if oracle supports multi-insert syntax, where you can specify more than one records' worth of data per statement. this will greatly speed up your queries.
turn autocommit off. this is an easy one. you may also have to wrap the inserts in a transaction.
disable indexes/keys if oracle supports it. then enable them at the end of the script.

perl -e'$_="nwdd\x7F^n\x7Flm{{llql0}qs\x14";s/./chr(ord$&^30)/ge;print'