Re: [phpOpenTracker-general] Does PhpOpenTracker can deal with this configuration ?

Hello Jean-Baptiste,

the API and the framework are very powerful so that is no problem to 
generate the data you wish. There is only a small customization 
neccessary in the simple_reports. So normally you don't have to touch 
the sql, only some PHP - knowledge is required to customize the 
simple_reports from the package to generate per week stats - per month 
is included.

As far as I can say, there will be another Problem: If you want to deal 
with so much traffic you will need a very, very powerful machine for the 
database, else it will take a very long time to generate the analysis. 
But I have only experience with POT on mysql. POT supports other DB's, 
but I don't whether a) they can handle so much data and b) I don't know 
anything about their performance and resource-hunger under that 
circumstances. Maybe someone else in the list has experiences with other 
DB's and POT.

You should know that POT makes a lot use of JOINS and TEMPORARY TABLES 
(or SUBSELECTS) to analyze the data, so that there are much more 
datasets to read than the one per pageview. For me the database-server 
was the bottle-neck. But it helped a lot to increase the caching time of 
POT.

Maybe it's an idea to use multiple POT-installations on a lot of 
different hosts. (BUT for this your NOT able to track returning visitors 
for the complete installation, because of cookies and hostnames. You 
will not be able to get unique visitors and returning visitors for the 
complete installation only for the POT-installation.)

So back to your question, I think POT can handle that volume of traffic, 
but you need a big machine, dedicated for POT. And you will have to 
change all "little websites" - to include the phpopentracker::log() call 
- or you use apache2 and mod_usertrack & convert this data to POT-data.

HTH

Andreas

Jean-Baptiste Clot schrieb:

>Hello,
>
>I plan to deploy PhpOpenTracker (with MS SQL as DB) for a free web hosting
>service :
>
>- 35 000  - 50 000 little web sites under one domain name (Total volume :  6
>000 000 pages views / month) Trafic grows 20% per month. 
>
>I've seen that PhpOpenTracker write a record in the DB for each hit. Do you
>think the learning curve is long (good knowledge with SQL, but medium with
>PHP & PEAR) to apply a patch that store a resume per week and per month of
>data ?
>
>MySQL with MERGE option it is a good alternative ? (with this volume)
>
>Thanks.
>
>JB
>
>_______________________________________________
>phpOpenTracker-General mailing list
>[email protected]
>http://lists.berlios.de/mailman/listinfo/phpopentracker-general
>
>  
>