Databases
StackOverflow2013
Postsdbo
POtrack visitor info on every request
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POtrack visitor info on every request
    text
    copied!<p>Using Asp.net webforms I want to track down visitor info just like Google Analytics does. Of course, I can use Google Analytic for this purpose but I want to know how can I achieve the same thing with Asp.net 3.5 and SQL Server 2008.</p> <p><strong>I want to store IP, Country, URL Referrer of the visitor, Resolution on each page request except postback. I am expecting 50k+ visit everyday.</strong>.</p> <p>Main concern is I want to do it in a way that it should not block current request. </p> <p>i.e In general it happens when we save data in to db, current request stops on particular SP calling statment and moves ahead when it finishes executing SP or tsql statement. I want to follow "Insert and Forget" approach. It should insert in background when I pass parameter to particular event or function.</p> <p>I found below alternatives for this :<br/> 1. <a href="http://msdn.microsoft.com/en-us/library/system.web.ui.pageasynctask.aspx" rel="nofollow"> PageAsynchTask</a><br/> 2. <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.beginexecutenonquery.aspx" rel="nofollow"> BeginExecuteNonQuery</a><br/> 3. Jquery Post method and Webservice (But I am not confident about this, and wondering how should I go about it)</p> <p>I hope I've mentioned my problem properly.</p> <p>Can anybody tell me which one is better approach? Also let me know if you've any other ideas or better approach than the listed one. Your help will be really appreciated. </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload