RE: Re: Is sqlplus too slow to unload data?]

2002-04-30 Thread ozemail
Stephane, pdqout does give me a real good impression, not only the speed but also the interface. I can see it uses parallel query. However, I, as a production DBA, intend to change the application which come from a third party as a package as small as possible. It takes 4hours to extract data at

RE: RE: Re: Is sqlplus too slow to unload data?]

2002-04-30 Thread Stephane Faroult
Stephane, pdqout does give me a real good impression, not only the speed but also the interface. I can see it uses parallel query. However, I, as a production DBA, intend to change the application which come from a third party as a package as small as possible. It takes 4hours to extract data

RE: Re: Is sqlplus too slow to unload data?

2002-04-24 Thread Stephane Faroult
As somebody who has insider's knowledge of pdqout and a decent understanding of exp and SQL*Plus, I think that you must have a good number of numbers and dates in your data. Both types (as opposed to strings) require conversion. Which is why exp, which dumps bytes 'as is', can be so fast -