How can i get the total rows of a table:
If i use "select count(*) from <tablename>" it will take lot of time to get the total row count.
for example in MSSQL we have "SELECT ROWS FROM sysindexes WHERE id = OBJECT_ID(<Tabl e name>) AND indid < 2"
I am looking some system index tables which hold the total rows as a statistic values of the table so that i can query that...
kveerareddy
Last Activity: Dec 8 '08, 12:55 PM
Joined: Nov 19 '08
Location:
-
Query to get total rows in a table in faster way.
-
kveerareddy replied to Invalidate the servlet session if session timeout even when UI automatically updatesin Javascript-- Presently we use Ajax request
-- we are not setting the session timeout, it is taking the tomcat session timeout bu default.
-- How to find out that there is no intaraction from the user and the time expired so that we can invalidate the session? -
kveerareddy replied to Invalidate the servlet session if session timeout even when UI automatically updatesin JavascriptThe page i am refering to has some connections and status information which will be checked for every 30 sec and update the GUI with the icons and message information.
The complete page is refreshed at this time.Leave a comment:
-
kveerareddy started a topic Invalidate the servlet session if session timeout even when UI automatically updatesin JavascriptInvalidate the servlet session if session timeout even when UI automatically updates
Hi experts,
Technologies: Spring, AJAX, Google web tool kit
Problem: Ideally when the user stops using a web page then after 30 minutes, if the user is trying to access any ting then the session gets expired.
But In my case one pages continually refreshes for every 30 seconds, hence not giving scope to session timeout even when the user stops using it.
Questions:
Is there any way to stop...
No activity results to display
Leave a comment: