Hi, How can I improve performance when using oracle dbd? We have an urgent performance problem where inserting data into an Oracle 9i database using DBI/DBD oracle is at least five times slower than stright sql using sqlplus. Any suggestion is appreciated.
Are you inserting records individually? If you are, you may get better performance by using execute_array to insert a bunch of records at a time.
Don