visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
315 experts, 1193 registered users, 1659 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Web :: Performance issues :: ASP Query versus SQL Query
By: VB guy Canada  Date: 20/09/2003 00:00:00  English  Points: 125 Status: Answered
Quality : Excellent
When programming an ASP webpage, I've heard that ASP queries take more processing power from the IIS server. Is this true? Or does the same query in SQL take the same processing power from SQL server.

What I have is an IIS 5.0 server connecting to a SQL 2000 server. What is the best method for programming?

Thanks
By: VGR Date: 21/09/2003 18:53:00 English  Type : Comment
there's no possible comparison between ASP (an interpreted scripting language) and SQL (the language recognized by RDBMS)

ASP WILL use SQL for the queries it passes to the underlying DB layer, as would PHP, ASP.Net/C#/VB, Cold Fusion, Net.Data or the like

If ASP is "slower" it's because it uses abstraction layers which are slowing the entire querying process (unduely IMHO). Those are ODBC, ADO.Net, JDBC, etc

Nothing will beat a scripting language with NATIVE (or almost-native) support for the underlying RDBMS. Of those, I can mention PHP when linking to Oracle, MySql, PostgreSql, etc

This said, normally and theoretically, on a 100% Merdu$oft platform, ASP should access in the most efficient manner the Microsoft "DBMS" underneath it, ie Access or SQL-Server, so I'm a bit surprised that you've been told this.

Of course, using IIS has also advantages and disadvantages you have to know of.
By: VB guy Date: 21/09/2003 23:18:00 English  Type : Comment
My system is a Win2K server with IIS 5.0 and SQL2000. So your saying that a query called by ASP would have about the same response time as a Command calling a query in SQL?
By: VGR Date: 21/09/2003 23:26:00 English  Type : Answer
heh. A part from overhead due to the webserver+interpreter module, and also the in-between-layer, there's no reason why not...

if you run the query using T-SQL , you'll measure a given execution time.

If you run it in an ASP page using a given DB access method (whatever, like ODBC), you'll measure the same time + overhead + rendering time in browser
By: VB guy Date: 22/09/2003 00:22:00 English  Type : Comment
That's the answer I was hoping for! :)

Thanks for your help!

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

EContact
browser fav
page generated in 338.152890 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page