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 to the web page. The table has 16 fields. It's OK, but if it's observed some web with huge traffic, the table has millions of records and performance (speed) is falling down. And the number of records in the table is still increasing.
So I consider to automatically create each month new (log) table for each user. The main disadvantage of this solution is fact that by 150 users will be cca 2500 tables in database after 1 year. But on the other hand, the tables have less records so the speed of analysing is higher. I don't know whether it's OK to have 2500 tables in one DB... It's also difficult to manage so big DB with phpMyAdmin. Can you help me? Thanks...
Don't create a table per user, but instead add a field in one table to reference this user, then you will have 150 times less tables to manage, therefore logging and truncation on a monthly basis wil be easier.
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
