Re: [phpOpenTracker-User] Speeding up OpenTracker Reporting

Hi Guys:

I have being reading this thread, and this is also a concern for me.
What do you think of this concept? If each month a summary is generated and
saved into a new table(s) for this purpose, then, when you need to have the
running total, a script would sum current month data and saved monthly total
data?

Regards,

Carlos Ch.


----- Original Message ----- 
From: "Jean-Christian Imbeault" <[email protected]>
To: <[email protected]>
Sent: Wednesday, September 24, 2003 9:14 PM
Subject: Re: [phpOpenTracker-User] Speeding up OpenTracker Reporting


> ? wrote:
> >
> > * It would be very usefull to archive old data to increase speed of
> > reports.
>
> I agree that would be a good thing to have. But I think that finding a
> way to make data retrieval faster is also just as important.
>
> > The site I track with phpOpenTracker now got about 380.000 access_log
> > entries in 5 months.
> > It needs more than 2 minutes time to generate the "Total Statistics"
> > report.
>
> I know what you mean. Imagine a site that gets > 10,000 log entries a
> day ... After a few months it becomes impossible to generate the report.
>
> Does anyone here use phpOpenTracker on a production site that gets a
> large amount of hits (>10K hits)? I am starting to worry that
> phpOpenTracker does not scale well.
>
> > * Idea for the example "simple_report": many users don't need all the
> > "Total Statisics" every time they enter phpOpenTracker.
> > A less time consuming report as "start"-page which shows all aviliable
> > months but not the other report sections. This gives the user the
> > chanche to navigate to a certain month more quickly.
>
> Sure. You can write one yourself too, it's not that hard. I have written
> a GUI front end to phpOpentracker to let you choose which report and for
> what time period. I'll be happy to post the code.
>
> Jean-Christian Imbeault
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpopencounter-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/phpopencounter-user
>
>




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf