How to - log queries
-
Hi All, I need to write a module to log all queries ran on a page. Once the page is loaded, limited users can pull this information with a click on client side to see. - This log should not be stored anywhere but in memory, which means the scope of this information is only the native page. Does anybody have any idea how this can be achieved? Any idea will be appreciated.
-
Hi All, I need to write a module to log all queries ran on a page. Once the page is loaded, limited users can pull this information with a click on client side to see. - This log should not be stored anywhere but in memory, which means the scope of this information is only the native page. Does anybody have any idea how this can be achieved? Any idea will be appreciated.
peacefulmember wrote:
I need to write a module to log all queries ran on a page
What kinda query? Do you mean operation like search etc...
peacefulmember wrote:
Once the page is loaded, limited users can pull this information with a click on client side to see.
Its upto you weather you want a client click or server click :laugh: As far as limited users are concerned, check for the permissions of the user. But as the information is at server, you need to make a server call.
-
peacefulmember wrote:
I need to write a module to log all queries ran on a page
What kinda query? Do you mean operation like search etc...
peacefulmember wrote:
Once the page is loaded, limited users can pull this information with a click on client side to see.
Its upto you weather you want a client click or server click :laugh: As far as limited users are concerned, check for the permissions of the user. But as the information is at server, you need to make a server call.
By queries I meant all the queries excuted to render one page. In my aplication one page is generated with multiple queries. Thus, I want user to click on a button (which I have on every page) and then see all the queries executed to build that page. I am not clear how a server call can help? These queries are neither stored on the database side nor I want to save it in a file or in database. I would like to achieve this by keeping it in memory or stream etc. I was thinking on either saving the sqls in javascript or was also thinking on lines of TraceListener. I am just not sure how? Anybody has better approach, please suggest with a solution. Thanks