what database to choose to store information about site visits, key characteristics: big amount of data, many page requests per second, different reports for data presentation, i think to use MySql, any suggestions?
A:
Most mainstream databases are good for that (including mysql, postgres, oracle etc). MySql is fine though, especially if you've used it before. Be sure look at licenses as well: MySql is GPL (the database and the connectors), Postgres is BSD, Oracle (and a few others) you need to pay for.
laura
2010-01-21 11:25:29
A:
Consider letting the server log the requests and parsing them asynchronously. You don't need ACID for analytics, and you don't need to process them while talking to a client.
Tobu
2010-01-21 12:26:16