UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Speed    
 
   
azizrasul
post Mar 5 2004, 01:52 PM
Post #1

UtterAccess Ruler
Posts: 1,068
From: Faisalabad, Pakistan
In terms of retrieving filtered data, which method is the fastest? Stored queries, domain functions or recordsets?
Go to the top of the page
 
+
khaos
post Mar 5 2004, 01:55 PM
Post #2

Retired Moderator
Posts: 8,589
From: Lansing, MI
Domain Functions are the slowest, a stored query should be the fastest since as a query runs multiple times it becomes optimized and therefore faster.

HTH
Ken
Go to the top of the page
 
+
AJS
post Mar 5 2004, 01:56 PM
Post #3

UtterAccess VIP
Posts: 3,893
From: Lansing, Michigan, USA
The Domain functions are notoriously slow.

For any but the simplest queries, I find I get the best performance if I use a saved query and open it as an ADO or DAO recordset.

-AJ
Go to the top of the page
 
+
R. Hicks
post Mar 5 2004, 01:56 PM
Post #4

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
A well designed query would be my choice althought it may not be a stored query.
I have not seen a noticable difference in a stored query or SQL executed in VBA code.
... although a stored query is supposed to be faster ...

The Domain Aggregate function would be that slowest ...

RDH
Go to the top of the page
 
+
azizrasul
post Mar 8 2004, 04:46 AM
Post #5

UtterAccess Ruler
Posts: 1,068
From: Faisalabad, Pakistan
When I said stored query, I meant creating a query which is then available in the Queries section. Is there a difference between a stored and saved query? What is meant by a saved query, isn't the same as a stored query?
Go to the top of the page
 
+
R. Hicks
post Mar 8 2004, 08:09 AM
Post #6

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
A stored query is one created and available in the Query window.
I use more queries that are SQL strings stored in VBA code ... that do no appear in the Query window.

RDH
Go to the top of the page
 
+
azizrasul
post Mar 8 2004, 08:42 AM
Post #7

UtterAccess Ruler
Posts: 1,068
From: Faisalabad, Pakistan
Thanks guys.
Go to the top of the page
 
+
R. Hicks
post Mar 8 2004, 08:50 AM
Post #8

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
No problem ... (IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)

RDH
Go to the top of the page
 
+
Bernie
post Mar 8 2004, 06:51 PM
Post #9

UtterAccess Addict
Posts: 139
From: Missouri, USA
Our system is so slow I finally started doing make table queries on form open.

It's weird. You'd think it'd take no longer to pull data from a server as the row source for a combo box in VB than it would to pull it down and make a table and then pull data from the table you made but, it is MUCH faster to pull it all down.

If I create the rowsource in VB directly from the server it takes over 5 seconds but I can pull it all down in VB and make a table and pull the data from it in less than 2.

Some things just don't make sense.
Go to the top of the page
 
+
« Next Oldest · Access Tables + Relationships · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 07:55 PM