Should I save a new query for each report or use the same and modi

N

Newbie09

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
 
S

Shane Devenshire

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One query for report and Excel 3
Multiple reports use same queries, how do I avoid rerunning querie 2
Access problem creating ACCESS query filtered by both check boxes and option groups. 0
How do I use same date parameters for different queries and report 1
Form and Query used for report 5
Query within a report 1
How do i show the date a report or query was last run? 2
Can the Report Update based on a Query being filtered? 3

Top