Re: [phpOpenTracker-User] Speeding up OpenTracker Reporting

Jean-Christian Imbeault <[email protected]> Fri, 26 Sep 2003 10:51:09 +0900
Newsgroups gmane.comp.web.phpopentracker.general
Message-ID <[email protected]>
Carlos Chiari (DE) wrote:

> 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?

That might work for reports except for clickpaths. It might be possible
to somehow generate a condensed version of the data needed for
clickpaths but I am not sure. Furthermore I think that there are some
other API calls that need access to all the data.

But I agree that were it helps to speed things up saving a condensed
version of the data is a good idea.

Jc



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