Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Should I save a new query for each report or use the same and modi
I have several reports that pull data from SQL and Oracle databases. I notice
the retrieval time from the Oracle database is much slower and have modified the queries to speed them up. My question is when I create a report, I do not save the query as a seperate query for that particular report. So the default query is always used I just change the parameters. Will saving seperate queries for each report gain me anything? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Should I save a new query for each report or use the same and modi
Try it and time one.
The execution speed of queries depends on many factors but I have never heard that this is one of them. Here are some factors: 1. Bandwidth 2. RAM 3. CPU 4. Version of Excel 5. Whether you filter records before they reach Excel. 6. Other open applications 7. Network usage 8. Database size 9. How many other users are working against the database (hense time of day is a good test of this) 10. Poorly written queries 11. Type of query 12. And... -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Newbie09" wrote: I have several reports that pull data from SQL and Oracle databases. I notice the retrieval time from the Oracle database is much slower and have modified the queries to speed them up. My question is when I create a report, I do not save the query as a seperate query for that particular report. So the default query is always used I just change the parameters. Will saving seperate queries for each report gain me anything? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query and Report Problem | Excel Discussion (Misc queries) | |||
.xlt files change from 300 dpi to 600 dpi when printing with MODI. | Excel Discussion (Misc queries) | |||
How do I get my dates in a report to export into my query? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Print Excel to MODI Writer? | Excel Discussion (Misc queries) |