Speed of Queries vs. Tables, etc.? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.03125