What fields are you using to select with?
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 8:09 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Question on Unidata tables access speeds
It is indexed on the key column, even then if I run the run the job
(query)
4 times in parallel, I am not getting advange of the parallel query.
Is Unidata not good for the parallel query ?, or is there any tuning
method ?
thanks
"Kevin King"
<[EMAIL PROTECTED] To:
[EMAIL PROTECTED]
> cc:
Sent by: Subject: RE:
[U2] Question on Unidata tables access speeds
[EMAIL PROTECTED]
er.u2ug.org
08/08/2004 06:09 PM
Please respond to
u2-users
Is anything indexed? Sounds like you could probably benefit from
adding some indexes on fields used for the selection. That would make
a BIG difference.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Sunday, August 08, 2004 3:57 PM
To: [EMAIL PROTECTED]
Subject: [U2] Question on Unidata tables access speeds
Hi ,
Project data warehouse, Sources are Unidata tables, tool Datastage.
Performance issue,
while dumping in to hash file(Allowing stage write cash). It is
searching
5.5 million
rows and fetching 2.6 million rows and taking 2.5 hours. There is only
one key column in the ouput. When I remove select caluse(I mean select
all rows) and put that filter in my tool, it is ok, but not great.
After that When I run parallel jobs , I mean select the data by 4 jobs
for different ranges(all at the same time), it is taking
4 times than normal time . In other words, I am not getting
performance like Oracle or other data bases. I am new to Unidata, is
there any method where I can get good access speeds on Unidata.Any
help will be highly appreciated.
thanks
pbr
----------------------------------------------------------------------
--------
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic
Communications Privacy Act, 18 U.S.C. 2510-2521, and is also
confidential and proprietary in nature. If you are not the intended
recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that
you have received this communication in error, and then immediately
delete it. Thank you in advance for your cooperation.
======================================================================
========
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
----------------------------------------------------------------------
--------
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic
Communications Privacy Act, 18 U.S.C. 2510-2521, and is also
confidential and proprietary in nature. If you are not the intended
recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that
you have received this communication in error, and then immediately
delete it. Thank you in advance for your cooperation.
======================================================================
========
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
