If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

slowly query

Started by silywiwi, 14 Sep 2007 03:05:33 AM

Previous topic - Next topic

silywiwi

     hi,everybody;)it is me again
  I union six table to  one table,and the records of table are more than ten thousand,it take me about 18 seconds to query one record from the table every time , it is too slow,can anybody have some suggestion to improve the time query uses?
thank in advance!

almeids

Run your query directly against the database to see whether the delay is in Reportnet or the db.  18 seconds seems way too long to scan tens of thousands of records even without an index.  Check your filters and generated sql, it sounds like all of the data is being retrieved and then scanned locally instead of filtered by the db.