In case of CustomerA, no of entries fetched from BSID is 246709 .
Because of this a standard piece of code takes a looong time to execute.
In case of Customer B, no of entries fetched from BSID is just 512.
Because of this less entries standard code executes faster.
Please suggest if some things can be deleted or cleaned up for this customer A from the table BSID.
What should be the steps taken to reduce the time of execution.
since this is a standard code, i cannot make changes too.
How can we clear up so many entries from BSID?
Can archiving be done?
what steps needs to be done to reduce the entries for CustomerA in table BSID.
Edited by: SuryaD on Dec 8, 2009 7:27 PM