Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: java array insert vs. batch
<velonews_at_gmail.com> wrote in message
news:1160713796.270871.207270_at_e3g2000cwe.googlegroups.com...
> All,
>
> o/s = CentOS
> db = 9.2 and 10.2
> driver = jdbc (thin)
> platform: two (2) dual core xeons 32-bit 2G ram local storage raid-0 (I
> know, I know)
>
> Target Outcome:
> insert records as fast as possible w/ java proggy
>
> - What is the difference between batching and array inserts?
> - Are array inserts in fact available for jdbc thin client?
> - If somebody could provide a code sample of array insert via
> java/jdbc, I would sure appreciate it
>
> Currently the best I can do w/ sqlldr (as a benchmark) is about 3K
> recs/sec (sqlldr invoked on db machine itself). java proggy (making
> net connection) is handcuffed at about 2K inserts/sec
>
> Thanks for any, all suggestions.
>
> - carlos
>
Benchmark. Make sure you use bind variables.(prepared statements)
Jim
Received on Fri Oct 13 2006 - 00:13:15 CDT