table configuration advice also for me!
Hello from Italy!
I'm going to create a php script that registers and reports stats for
20/30 externals sites (with about 2.000 daily visitors each one).
I need to configure the tables (mysql) where I would store visitors data.
I need help to choose between these solutions:
a) two table visitors and visits whit a field site_id to distinguish
between monitorated sites visitors
b) two table for each site: site_1_visitors, site_1_visits,
site_2_visitors, site_2_visits etc...
What do you think about it?