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!
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.