I am retrieving data from a table which has huge data, around 10,00000 records.I dont have any indexes and i am retrieving based on around 70 fields. I am doing through a COM component and i am using MTS. since the data is huge and processing time is lot, i am getting error saying "omponent-request-denied" and giving an option like SWITCH or RETRY. Can some one help me how to handle this situation.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.