Re: Speeding up multiple inserts

From: Justin Cave <jocave_at_yahoo.com>
Date: 1 Oct 2002 12:12:58 -0700
Message-ID: <233b7a65.0210011112.3fd05960@posting.google.com>

poncz_at_hotmail.com (Miko) wrote in message news:<3b8c19dd.0210010059.195752b2_at_posting.google.com>...
> My web server does ~1000 insert query per second (many index on the tables)

How often are you committing? Protocols like ODBC, JDBC, etc. will usually default to 'auto-commit' behavior-- committing after every statement. If you can afford to decrease the frequency of commits, you can get some pretty impressive performance benefits.

> But all the queries are the same (same query different parameters)

Does this imply you are using bind variables? If not, you're forcing Oracle to re-parse the query for each new literal.

Justin Cave Received on Tue Oct 01 2002 - 14:12:58 CDT