× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

Select on ACCOUNT in a nofile enquiry

Start
Prev
1
Next
End

vmajish
Topic Author
Offline
New Member

9 years 5 months ago #16483 by vmajish

Select on ACCOUNT in a nofile enquiry was created by vmajish

Hi All,

Need some help/inputs with the below query.... Thanks in advance.

we have selects on AZ.ACCOUNT and AC.LOCKED.EVENTS tables (Oracle) with 34399 and 13715 records respectively. The enquiry when launched times outs.

We would be happy to make it work in online, through enquiry report and or attaching to a TSA service.

I request you to suggest us a solutions that could help us make the enquiry work.

I have the same issue with another nofile enquiry which has selection ACCOUNT with 942909 records in it.

Thanks
Ajish Ahammed.

Please Log in or Create an account to join the conversation.

kripesh
Offline
Platinum Member

9 years 5 months ago #16489 by kripesh

Replied by kripesh on topic Select on ACCOUNT in a nofile enquiry

Paste your Enquiry subroutine...

Have a great day !

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
TAFj-R20 - 'unix'

9 years 5 months ago #16495 by jpb

Replied by jpb on topic Select on ACCOUNT in a nofile enquiry

Beside increasing the timeout interval have you tried defining/using indexes for the used selections (for jBase with CREATE-INDEX; for Oracle with CREATE-EXTINDEX) ?

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.108 seconds