how to decrease the query execution time???

[everlearner]

Hi gurus,

am pulling the data from same database for 2 list reports.in two queries i have used same filters. first query executing in less than 5 mins where as second one taking more than 15 mins... second list has five calculated columns, due to that it is taking much time??? how can i decrease the execution time to increase the perfomance???


thanks in adv

[Grim]

Without knowing what your data is or what data your pulling or how much...you could try the following....

Change processing to  DB Only.
You could also see if this helps...
http://www.ibm.com/support/docview.wss?uid=swg21344305

[blom0344]

Using the caching of data is great when developing a report, since it may take less time to check results on for instance altered layout. In production it may be hazardous if underlying data can change during a session. This may lead to 'missing' data from the users perspective just BECAUSE no new call to the database is made. You are then effectively looking at 'old' data.

Changing to DB only will severely limit the possibilities within queries, but may be useful for very simple queries.  A list report that takes 5 -15 minutes ?  I suspect that your database queries are extremely costly then. I would take a look at optimizing at the databases side..