Re: select 10000 rows from Oracle in shortest way
- From: Roedy Green <my_email_is_posted_on_my_website@xxxxxxxxxxxxxx>
- Date: Mon, 23 Jan 2006 20:39:52 GMT
On 23 Jan 2006 02:27:08 -0800, "dok" <dok@xxxxxxxxxxx> wrote, quoted
or indirectly quoted someone who said :
>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.
import/export tends to be much faster than spoon feeding a row at a
time. Databases tend to turn off the transaction backout logic on
import.
--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
.
- Follow-Ups:
- References:
- Prev by Date: Re: Generic Oracle DB Mngr
- Next by Date: Re: select 10000 rows from Oracle in shortest way
- Previous by thread: Re: select 10000 rows from Oracle in shortest way
- Next by thread: Re: select 10000 rows from Oracle in shortest way
- Index(es):
Relevant Pages
|
|
