Oracle vs datasets

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Oracle vs datasets

Post by admin »

Hi Guys,

Performance wise which one is faster : read/write from/to oracle table OR
read/write from/to .ds.

Please let me know.

Thanks.

Raj






*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
*************************************************************************

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Oracle vs datasets

Post by admin »

Hi Raj,
I have never tested this or measured it so my comments are a gut feel. As
long as you have configured your config file and resource diskS well to
maximise IO, I would say Dataset.

It would to hard to test though, give it a try. :-)

Stewart

-----Original Message-----
From: Rajesh.Bhat@hartfordlife.com [mailto:Rajesh.Bhat@hartfordlife.com]
Sent: Tuesday, 9 March 2004 9:35 AM
To: datastage-users@oliver.com
Subject: Oracle vs datasets

Hi Guys,

Performance wise which one is faster : read/write from/to oracle table OR
read/write from/to .ds.

Please let me know.

Thanks.

Raj






*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary, confidential
and/or privileged information. If you are not the intended recipient, any
use, copying, disclosure, dissemination or distribution is strictly
prohibited. If you are not the intended recipient, please notify the sender
immediately by return e-mail, delete this communication and destroy all
copies.
*************************************************************************

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked