High database load from Ajax Edit Comments…

… and a preliminary solution:

The WordPress plugin “Ajax Edit Comments” from The Reader Appreciation Project1 allows the commenter to edit his comment for a certain time – useful especially for typos and minor corrections. (Admins can do more.) Visitors utilize it here for about every 10th comment, by the way.

Now Pierre notified me yesterday about the high number of database queries (and that the response time could be better, too) – higher than what I always saw when logged in. (See the blue footer line.) Doing a little research, I found that it’s the aforementioned Ajax Edit Comments that uses 4 additional database queries for each comment in order to check if the visitor is allowed to edit it (unles (s)he’s logged in as admin who is always allowed to edit). That can sum up to quite a lot if there are many comments on a single post.

I quickly added a little modification to the plugin2 which check the comment age in advance without database access – in my quick tests, these modifications appear to work fine. If you too don’t see any problems – feel free to test it here or maybe later for the music quiz on 16:00 – I will, of course, send the changes to the plugin’s author, hoping they will be included in future versions. :)

  1. for WordPress 2.5 and higher – old version for 2.1–2.3.x here ↺
  2. in both the old version I’m still using here and the new in my test environment where I’m preparing the WordPress 2.7 update ↺

0.06% articles reduced!

Über 50 Artikel reduziert!

It is somewhat funny1 if a large mail-order company like Neckermann is advertising “Over 50 articles reduced!”, isn’t it?

Alright, that of course only applies to the articles that are advertised in the ad letter (with the usual 10€ voucher, of course) – however, it’s still odd, given how many articles they have in total: 85,958 when adding the numbers they give in their categories on their website, maybe plus 6095 chrismas things if they are not also listed in the other categories.

(Of course I should mention that their bargain category contains 14,988 articles, so really not just those few they mentioned in the letter.)

  1. if not to you, then, well, ignore this post ;)  ↺

Statistical aftermath

Now what are the results – as far as they concern myself – of the incredible TV muck, erm, “experiment” called “Uri Geller live – Ufos & Aliens” about which I reported more or less live?

  • Uris Aliens: WP.com-Stats A new record on Saturday that didn’t last long: WP.com-Stats counted 2826 page views (probably not 12am CET being their limit, but UTC), including 768 for the pre-report and 1120 for the live report. The best value since the start of my blog, even better than the 2549 in February – also thanks to Uri Geller.
    The visitor run continued on Sunday: 3068 total, 1126 for the pre-report and 809 for the live report. On early Sunday afternoon, the average of the last 6 months was already reached in November.
  • Almost all searchers arrived at the pre-report initially – which I expected and placed a big link there. (And of course this also contributed to the high total page views.) The pre-report was also in Google.de’s top 5 for several search word combinations, sometimes even ahead of ProSieben, the show’s TV station. :mrgreen: And the highest-placed blog.
  • Uris Aliens: Bloggerei Bloggerei.de counted on Saturday until midnight 423 unique visitors1 for the live report, which was enough for no. 12 in the top topics list; there were a total of 1295 visitors on Saturday. (Which also means that another estimated 350-400 visitors were satisfied with the pre-report. Or unsatisfied and left again. Or didn’t notice the link after all.)
    On Sunday, I temporarily reached no. 5 in the top topics and rank 28 in the top blogs list, as far as I noticed (there’s no history) – 2110 unique visitors total, about 700 for the live report.
  • Uris Aliens: Broswer-Statistik Seiten
    Uris Aliens: Broswer-Statistik Besucher
    Addendum: Originally I had left out the data from browser-statistik.de in order to not overload this post with numbers, but since Jan, who operates the site, cried so heart-rendingly (“ :cry: ”), I added them now: 2751 pages accessed by 1111 visitors on Saturday, 3061 pages by 2002 visitors on Sunday. Which put me on no. 9 on the charts there.
  • Uris Aliens: whos.amung.us According to whos.amung.us, there were up to 53 online at the same time – even if that tool isn’t known for its reliability, it rather has outages (sometimes for hours) than counting too much.
  • Originally I had planned to update my report in every or every other commercial break – but when there still was none on 9pm (there apparently were rather few commercial customers), I quickly uploaded the first part (in German) anyway; after all, there were already several readers and a few comments.
  • 13 commenters wrote 35 comments during the show; more were added later on – thanks!

The ratings were surprisingly low, rather disastrous for ProSieben – here’s the top 5 of Saturday’s primetime (source: teletexts):

Station Show Viewers
aged 3+
Marktet share Viewers
14-49 years
Market share
Sat.1 Chronicles of Narnia (movie) 5.56 Mio. 18.9% 3.25 Mio 27.6%
RTL Das Supertalent (casting show) 5.55 Mio. 18.8% 3.09 Mio. 26.2%
ARD Musikantenstadl (“folk” music) 5.32 Mio. 17.8%
ZDF Unter Verdacht (TV movie) 4.57 Mio. 15.2%
Pro7 Uri Geller live 1.40 Mio. 4.8% 0.85 Mio. 7.3%
Rerun on Sunday morning 0.54 Mio. 6.1% 0.38 Mio. 8.6%

Now does ARD being that far ahead of Pro7 speak for the intelligence of the TV audience or against it…?

  1. 423? 42 and 23 blended together? Conspiracy!!!! ↺

At what time of day is waning moon in 2008?

Ausschau haltend Welcome to the latest edition of “replying” to search queries

For those who don’t know yet: These search phrases, highlighted in grey, led people here, and I neither shortened nor extended them nor made them up, I just translated the German ones.

At what time of day is waning moon in 2008
At 4:08, 15:16 and 23:42. But I won’t tell you the day!

if there was a god would let me find what im looking for here?
That’s the proof of the non-existence of a god: You did not find what you were looking for!

photos of lady chastity-belt
Sorry, I don’t know a Lady Chastity-Belt. That really is a strange name.

geometric figure bring good luck
Geometric figure brings nothing. Not even as…

medicine.to.paint.on.com
It’s known that some people enter URLs into the search box, but using dots everywhere?

flower lice new homeopathy körbler
See, your flower’s got lice now – that’s the result of your lunacy.

please find two guy making love & kissing & lying photo
Are there any studies if politeness towards search engines leads to faster and/or better results?

porn after 12
After 12 is before 12.

The song woamen from whom is that
Wo Amen? Gotta be some Christian band, but that’s nothing I know about.

Advent advent a little light shines
ooo yeah this thing is on fire
I think it’s time
No, two weeks early!

which lotto numbers are standing good today
None, because either the drawing balls are lying in their box, or during the drawing they are rolling around. I never heard of balls standing, they’re no eggs of Columbus anyway.

las palabras always–at-because-first-in-is-like-live-takes-then-to-bet-wear-eat-get-up-goes
Errrm… what-do-you-mean?

:bye: Before there are more like this one: it’s the end for today, bye, and remember: man fuck anybody that read this cause Im stair get up like jesus.


Photo: Coka – Fotolia.com