Re: [phpOpenTracker-User] split_tables

Sebastian Bergmann <[email protected]> Wed, 01 Oct 2003 18:13:02 +0200
Newsgroups gmane.comp.web.phpopentracker.general
Organization www.sebastian-bergmann.de
Message-ID <[email protected]>
Thiess Rathjen wrote:
> My pot_accesslog and pot_visitors tables are now  separated by
> months.

  Good.

> To make my first successful queries i had to update my mysql to a
> version >= 3.23.54 to create temporary merge tables.

  I will make a note about this in the manual, thanks for the hint.

> I am not sure how you deal with the change of months. Today the first
> updates in the pot database results in arising three new
> pot_accesslog tables up to december.

  To avoid the overhead of creating new tables each month the handler
  always creates new tables for every remaining month of the current year.

> But the pot_visitors have not been touched. I wonder why. Do i overlook
> something?

  That is odd, I'll look into this as soon as I find the time.

  Greetings,
Sebastian

-- 
Sebastian Bergmann
http://sebastian-bergmann.de/                   http://phpOpenTracker.de/

Das Buch zu PHP 5: http://professionelle-softwareentwicklung-mit-php5.de/


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