performence of report

thanks for reading this post,

i have a report in that they are fetching the data from custinvoicejour and we have a additional requirement to fetch the misc. charges from inventtrans. i wrote the logic in display method of that control and through while select statement i am fetching the data. i am getting the desired output but it is taking the long time. we dont have any fetch method in that means without fetch method i am getting the data. but it is taking the long time around 30 mins. is there anyway to improve the performence of the report.

Thanks in advance…


Hope helps u to misc cal’s

Try to filter while loops to reduce the execution time

Try to filter while loops to reduce the execution time

avoid while loops .looks like you are making many trips to database. change the logic to reduce number of trips and get chunks of data in one trip.

go through all these steps , that might help you.

  • Include a try catch around all transactions that could result in deadlock.

  • Make sure the try for a deadlock is idempotent meaning no matter how many times the try is attempted, it will yield the same result.

  • Consider the clarity when deciding the number of return statements in a method.

  • Use throw instead of ttsAbort.

  • Avoid display methods where possible.

  • Set Optimistic Concurrency Control (OccEnabled) to Yes for most tables.

  • Do not include user interaction inside a database transaction.

  • Keep database transactions as short as possible.

  • Run code on the Application Object Server (AOS) whenever possible.

  • Use where clauses in select statements and in queries that align with indexes.

  • If method calls are used to test conditions, put the method calls after the other conditions. If the other conditions fail, then you will not incur the cost of running the method.

  • Minimize the size of database transactions.

  • Consider specifying a field list in select statements to increase performance.

  • Use firstonly where applicable to increase performance.

  • Use aggregates in the selection criteria instead of having the code do the aggregation. If aggregations are issued in the select statement rather than in code, the processing is done at the database server which is much more efficient.

  • Use table joins instead of nested while loops. Whenever possible use a join in the select statement rather than using a while loop and then an inner while loop on the related table. This reduces the amount of communication between the AOS and the database.

  • Do not include any sort of user interaction in a transaction.

thankyou all i got the solution in another way…