|
| |
|
|
Botcollector
Posts: 69
From: None
Status: offline
 |
Speed of Queries vs. Tables, etc.? - 3/25/2001 20:36:00
Is there any evidence concerning the speed/efficiency of ASP and Access objects in terms of what's better to use?For instance, will a page load quicker if the DRW is based on a Query that's made to just use the data items in the ASP page, rather than if the ASP page looks at a table with more fields than are in the DRW page? Is there ANY difference? Any reason to use one or the other? Thanks for any feedback.
The Bot Collector
|
|
|
|
Spooky
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Speed of Queries vs. Tables, etc.? - 3/25/2001 19:04:00
Its always better to use a query.
You can design the recordset to be returned so that it only contains the relevant information.
Its a known fact that Stored procedures (in SQL anyway) are way faster.
Its a good way to display joins etc as well
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
