CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!



Zone: > NEWSGROUP > Asp.Net Forum > migration_to_asp.net.migrating_from_cold_fusion_to_asp.net Tags:
Item Type: NewsGroup Date Entered: 2/16/2008 11:08:31 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 32 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
usp
Asp.Net User
List of all query execution times for a page2/16/2008 11:08:31 PM

0/0

Does anyone know how to get a list of all the database queries that were executed for a given page request, like is shown at the bottom of ColdFusion pages when debug output is turned on? I would also like to see execution times. This would be much more convenient than running a SQL Profiler trace, and also hopefully more accurate since it will account for the overhead of loading data into the application, not just the database query time. I am using VB.NET with ASP.NET 2.0

commadercody
Asp.Net User
Re: List of all query execution times for a page3/11/2008 8:06:13 PM

0/0

Take a look at using Ajax in your ASP.NET and this link:

http://weblogs.asp.net/romannikitin/archive/2007/11/22/sys-debug-in-asp-net-ajax-framework.aspx

Also this thread:

http://forums.asp.net/p/1203581/2183313.aspx


"From my point of view, the Jedi are evil!"
2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Readings in Database Systems Authors: Joseph M. Hellerstein, Michael Stonebraker, Pages: 865, Published: 2005
Conceptual Structures Knowledge Architectures for Smart Applications: 15th International Conference on Conceptual Structures, ICCS 2007, Sheffield, UK, July 22-27, 2007 : Proceedings Authors: Uta Priss, Simon Polovina, Richard Hill, Pages: 514, Published: 2007
Proceedings of the Twenty-ninth International Conference on Very Large Databases, Berlin, Germany, 9-12 September, 2003: 9-12- September 2003 Berlin, Germany Authors: Johann Christoph Freytag, Pages: 1151, Published: 2003
Pro MySQL Authors: Michael Kruckenberg, Jay Pipes, Pages: 734, Published: 2005
Proceedings: Seventh International Conference on Data Engineering, April 8-12, 1991 Kobe, Japan Authors: IEEE Computer Society, Pages: 766, Published: 1991
Pro LINQ: Language Integrated Query in C# 2008 Authors: Joseph C. Rattz, Joseph C Rattz, Jr, Pages: 600, Published: 2007
Proceedings of the First International Conference on Parallel and Distributed Information Systems: December 4-6, 1991, Fontainebleu Hilton Resort, Miami Beach, Florida Authors: Association for Computing Machinery Special Interest Group on Management of Data, Institute of Electrical and Electronics Engineers, ACM Special Interest Group on Management of Data, Pages: 292, Published: 1991
Mastering Unix Shell Scripting Authors: Randal K. Michael, Pages: 680, Published: 2003
Proceedings of the Fifteenth International Conference on Very Large Data Bases: August 22-25, 1989, Amsterdam, The Netherlands Authors: Petrus Maria Gerardus Apers, Gio Wiederhold, VLDB Endowment, Pages: 467, Published: 1989

Web:
List of all query execution times for a page - ASP.NET Forums Hmm [^o)] List of all query execution times for a page ... Re: List of all query execution times for a page ...
MySQL :: MySQL 5.0 Reference Manual :: 15.10 The Query Analyzer Page To filter the list of queries that are displayed, or to change the number of queries, ... Exec Time — the execution time for all the matching queries. ...
MySQL :: MySQL 5.1 with Maria Reference Manual :: 15.10 The Query ... You can see an example of the table on that page in the figure below. Figure 15.45. Query ... Exec Time — the execution time for all the matching queries. ...
Page execution time much higher than query execution time. But why ... Page execution time should be a litlle bit higher than query .... all those fancy URL aliases if I knew page execution time would be higher. ...
Query Execution Times - Mambo - Forums Closed for posting Query Execution Times Mambo 4.6 Wish List. ... Speed up Page Load Times and More by gzipping your CSS, booger, Tips & Tricks, 0, May 24th, ...
Optimizing ColdFusion queries by reordering SQL clauses May 21, 2008 ... Because this query runs in 20?60 milliseconds, it reduces the average execution time on any edit page to less than 2 seconds. ...
Query plans If several eligible STAR indexes exist, the server includes a list of the best ... Execution time decisions. All query plans start with a Red Brick EXECUTE ...
Welcome to SQL Server Blog: To retrieve the query execution time Mar 8, 2008 ... To retrieve the query execution time. CURRENT_TIMESTAMP is used to retrieve the current time. By using this system function we can compare ...
ADOdb Lite Commands $db->query_list_time // List of all executed queries execution times ... enabled the page will open another window displaying all of the query information. ...




Search This Site:










coldfusion vs asp

sql select statement

cf and .net framework side by side?

to if, or not to if

web.config similar to application.cfc (or application.cfm)

list of all query execution times for a page

whats better? coldfusion or visual studio.net & asp.net ??

questionnaires

from cold fusion to...c# or vb...?

specification for cfm to .net migration

sharing/passing data between coldfusion and asp.net

migrating from coldfusion to .net

changing coldfusion queries to store procedures

asp to clear cache?

client server (vb7) versus thin client (asp.net)

decrypting passwords encrypted using cold fusion encrypt

asp.net driving me nuts

three selects lists (dropdowns) related

who is ben forta's asp.net?

coldfusion to asp.net automatic conversion tool.

converting coldfusion to asp.net

event calendar

any sites or samples that shows coldfusion & asp.net working together?

current cf dev with some questions about migrating over...

newb coming from cf

cold fusion can do it! how can i get vb to do it?

using asp.net on a coldfusion hosted server

is it possible to duplicate cf schedule in asp.net?

<cfoutput> group attribute

treeview navigateurl

  Privacy | Contact Us
All Times Are GMT