Re: How to design effective MySQL DB for multi-user web tracker system?

2005-05-03 Thread Philippe Poelvoorde
jkj kjhkjhk wrote: Hi, I develop multi-user web tracker system (php+mysql). In these days I have cca 150 users and each of the users has a set of the tables which are all included in central DB. In DB is on the whole cca 900 tables. Each user has also one (log) table in which are logged accesses t

How to design effective MySQL DB for multi-user web tracker system?

2005-04-30 Thread jkj kjhkjhk
Hi, I develop multi-user web tracker system (php+mysql). In these days I have cca 150 users and each of the users has a set of the tables which are all included in central DB. In DB is on the whole cca 900 tables. Each user has also one (log) table in which are logged accesses to the web pag