Re: select 10000 rows from Oracle in shortest way

On 23.01.2006 11:27 dok wrote: 
Looking for a good desicions for trasfering more than  10000 rows from
oracle to mysql using only jdbc. Connect is mostly slow about 1 row in
a second, rights on oracle are just for select, update, insert
operations. I think if I can devide 10000 rows in 10 parts and transfer
them in concurent threads and connections. Any suggestion can help me
to solve this problem.


I can copy 10000 rows in about 40 seconds (pure JDBC).

But I have noted, that insert speed is extremely slow when autocommit is turned on. So maybe that is your problem?

Thomas

--
It's not a RootKit - it's a Sony
.

Relevant Pages

  • Re: OT: How I learned to stop worrying and love the RDBMS
    ... not used either to replace TurboIMAGE for a migration client. ... Oracle and DB2 to replace TurboIMAGE for migration clients and our partners ... MySQL has become. ... The primary reason for our Oracle, DB2 and MS SQL Server emphasis is because ...
    (comp.sys.hp.mpe)
  • Re: How to query a Date Column in SQL
    ... > I am in the process of refactoring a Java application which uses JDBC ... > to talk to Oracle and MySQL. ... > field that was represented in the database as a text field, ... MySQL JDBC drivers will support the escape sequence. ...
    (comp.lang.java.databases)
  • Re: MySQLdb slow on MySQL 5
    ... Oracle bought a small Finnish ... company which developed the transaction-aware table- ... backend for MySQL. ... It's one thing if Oracle fails to comply to all standards, ...
    (comp.lang.python)
  • Re: Oracle vs MySql Performance
    ... Performance on MySql was adequate but as our primary DB platform is ... Oracle we influenced the 3rd part to introduce an Oracle version (NB: ... To facilitate this process the vendor has used almost pure ANSI Sql so ... Look at the wait events in the raw trace file for clues ...
    (comp.databases.oracle.server)
  • Re: Select count(*) in Oracle and MySQL
    ... The same query in Oracle takes about 6 minutes, ... The MySQL table has no primary key either. ... you either don't know how to use a DBMS like Oracle (given ...
    (comp.databases.oracle.server)