Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: performance of Inserting bytes
Hi Aseem,
Did you find solution to your problem.
Actually, I am also having the same problem.
Thanks,
-Kevin
aseem_at_modena.stpn.soft.net (Aseem Bansal) wrote in message news:<dba22635.0207110540.7982d7cd_at_posting.google.com>...
> Hi
> I donot have much idea about the slow performance regarding the
> insert statement execution.
> I am using Oracle JDBC driver (Classes12.zip) for accessing
> oracle 8.1.6. In the database, I am maintaining a message table which
> has 6 fields (4 numbers, 1 char and 1 "LONG RAW " ). If i try to
> insert 5000 messages into this table using a single prepared
> statement, performance is around 60-80 inserts per sec (always <
> 100). How can I increase this?
>
>
> Regards
> Aseem Bansal
Received on Fri Jul 19 2002 - 23:48:17 CDT