Installing A Database Server
|
|
||
WhosOn can optionally use a SQL Database server to store visitor data. Using a SQL Database has a number of advantages:
- You can use the Web Charts module to view web analytic reports remotely via a browser.
- You can create custom SQL queries to view using the Web Charts or Windows based Charts & Reports viewer.
- You can access the data via 3rd party tools.
- If you are monitoring many sites or very busy sites a SQL database will give better performance.
WhosOn can use any of the following database servers:
| • | Microsoft SQL Server 2008 |
| • | Microsoft SQL Server 2005 |
| • | Microsoft SQL Server 2005/2008 Express (free) (recommended) |
We recommend using SQL Server 2005 or 2008 Express for overall ease of use and performance. We recommend you run this on the same PC as WhosOn itself. Whilst it is possible to connect to, and update a database server running on another PC we don't recommend it as performance will suffer.
See Also: