MySQL Tables

[Anon]

Hi,

Is there any way to make a php script that, when a mysql table reach for example : 3000 entries, it creates another named like table_2 and same thing when this table reaches max hits...

Thanks,
Max

[[deleted]]

Yes, but what do you need this for?

[Anon]

Because we're developing a free counter. And if our tables are big files, it is slower to get the datas.

[calevans]

A better solution might be to run a nightly query and archive hits older than x time units to an archive table of the same structure. Then your main table will remain smaller but you still have the ability to query all the results.

The idea of creating a new table every x records is going to be a nightmare very quickly.

HTH,
Cal
http://www.calevans.com

[[deleted]]

If you just want to count hits to pages, you only need one record per page.
If you use proper indexes and a smart layout, you can get excellent performance on multi-million row columns.
I would sooner devide the tables by domain/ip number than by size.