March 9, 2009 at 12:17 am
In record set I have loaded the lacs of records in application,
It Says time out expired error, But I know this error will start from poor Query I just fetch the values like
"select acct_code, doc_type, debit_amount , credit_amount etc... from ledger_dtl where some condition "
but it takes more then 5 min, so that error has coming.. How can we reduce the execution time..
Please Help me...
March 9, 2009 at 12:21 am
how many rows are returned?
Make sure that you fetch the needed columns only.
Create a view and create index for fast retrieval of data(anyhow using index is not advisable if the table is vulnerable for frequent update)
March 9, 2009 at 12:28 am
can u give me a small example like create view and Index?
please..
March 9, 2009 at 1:16 am
Most of the performance issues arises because of badly written query, improper indexes or excess fragmentation or no enough statistics etc.
So, if you can you provide us with the actual query and the execution plans attached as plan files then we can help us identifying the issue.
--Ramesh
March 9, 2009 at 3:08 am
[font="Arial"]Please don't waste your time I got a Solution.. Thanks for Reply[/font]
March 9, 2009 at 3:15 am
Hey buddy we are not here to waste time. Rather we are here to help each other. Since you got the solution you should post it here and close the post.
"Keep Trying"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply