Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: performance of Inserting bytes

Re: performance of Inserting bytes

From: Kevin Epsworth <kevinepsworth_at_bigfoot.com>
Date: 19 Jul 2002 21:48:17 -0700
Message-ID: <8cdb4228.0207192048.1c26ecb4@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US