Re: Bulk Data Transfer b/w oracle - SQL anywhere

Dunamic SQL is always slow. How are you looking for changes? What does the explain plan look like for hte queries you are executing?

Some sort of bulk load would probably be much faster.

rr

andy_price_at_my-dejanews.com wrote:

> hi all,
>
> I am trying to read data from remote oracle db and insert into SQL Anywhere
> using PB. I loop thru all tables and look for changes in Oracle then insert.
> With dynamic sql and it sucks !! any better ideas ??
>
> has anyone done such things using flatfiles ? HELP !!!
>
> tx
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Thu Apr 08 1999 - 11:25:35 CDT