Re: [phpOpenTracker-User] Speeding up OpenTracker Reporting

Jean-Christian Imbeault <[email protected]> Fri, 26 Sep 2003 15:07:02 +0900
Newsgroups gmane.comp.web.phpopentracker.general
Message-ID <[email protected]>
Sebastian Bergmann wrote:

>   This is exactly the problem the MySQL Merge Tables handler adresses by
>   maintaining separate pot_accesslog and pot_visitors tables for each
>   month.

Any chance of a solution for non-MySQL users? :)

I haven't looked into it but other than optimizing the SQL queries do
you have any other ideas that are more generic and could be more easily
ported to other database? The first thing that comes to mind is
optimizing the SQL queries but my guess is that your queries are already
optimzed as much as possible.

Jean-Christian Imbeault



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