| using reports 6i, instead of parsing query everytime can i sotre the query in database [message #83137] |
Mon, 11 August 2003 00:19 |
Ankush
Messages: 18
Registered: July 2002
|
Junior Member |
|
|
Dear All,
I m using report 6i, my prob. is that i have created one report which is fetching emp. information from emp table based on employee name which is passed through variable. means this variable gets change everytime and report gets data from emp table. this report is used by multiple users. when several users fires report at a time, reports takes very long time to execute, can anybody tell me instead of parsing
query everytime, can i store is somewhere
note : i checked the indexes/table locking evrything is fine.
hint : query gets parse everytime which cause long time.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
