Re: Maximum Number of Table in MyISAM
Posted by:
Joel Loh
Date: August 21, 2006 09:01PM
Thanks for your reply! but..., as u can see, i'm developing a system that keep track of USER web statistic, hits, view, visit where from, IP.......
1) As this issue, we can understand that each USER can have Multiple webpage.
Lets say, if the USER have 10 webpage for me to track, and each wepage have
an everage of 10,000 visitor.
which mean... 10 webpage x 10,000 record = 100,000 record in a single table. IF 1000 USER register with me.., which mean...
1000 user x 10 webpage for each USER x 100,000 data = 1,000,000,000 in 1 table in a SINGLE DAY.
For your refrence, i'm USING a hosting company that USING Linux server. Can u advises me?