Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

  1. Index
  2. » Archives
  3. » Users Currently Online

#37 2006-12-13 21:00:59

Manfre
Plugin Author
From: North Carolina
Registered: 2004-05-22
Posts: 588
Website

Re: Users Currently Online

The query took over 4 seconds. You should drop the timeout to a lower value (300 or lower). After doing this, check the tag trace to see how long the query took. I suspect that the UNIX_TIMESTAMP(time) is slowing things down. I will look in to optimizing the query a little bit more and possible adding a table index to make it run faster. I am also going to add to my todo list, the ability to have it cache the result for a configurable amount of time, instead of calculating every page load.

Offline

#38 2006-12-13 21:17:52

Manfre
Plugin Author
From: North Carolina
Registered: 2004-05-22
Posts: 588
Website

Re: Users Currently Online

Okay, I made a small change that should speed things up a little bit. Download 0.3 and give that a go.

Changes:
- timeout arg defaults to 300 instead of 600
- No longer using UNIX_TIMESTAMP

Offline

  1. Index
  2. » Archives
  3. » Users Currently Online

Board footer

Powered by FluxBB