Blogging Roller

Dave Johnson on open web technologies, social software and Java

Above: a random selection of photos from my Flickr photo-stream.

Tuesday Jan 06, 2004

Couple more indexes.

Rick Ross and I were trying to diagnose some heavier-than-usual load on JRoller last night by watching the MySQL query log. We noticed that some queries were still examining way too many rows and based on this we came up with a couple of additional indexes. After we applied the new indexes, load returned to normal levels (i.e. less than 0.1). These should work on either Roller 0.9.8 or Roller 0.9.9-dev and they will be included in future releases in either branch: 

create index userrole_username_index on userrole( username );
create index weblogentry_pubtime_index on weblogentry( pubtime, publishentry, websiteid );
Dave in Roller Comments[3]

Tags: Roller

Welcome

This is my personal blog where I write about open technologies, social software, web development, Java and generally whatever I want to write about. See the about page for more information. Click the link below to subscribe via your favorite feed reader:

Wayin

The widget below shows my Wayin stream. Hold your mouse over the image for voting options. And if you don't have an account yet, then sign up! It's free.


Follow me

If you know me, follow, connect or friend me on the social network services I use:

Hot tags

Below are the thirty most often used tags in the blog. Hover over a tag to see a count of entries, click a tag to see the most recent posts with the tag.

The latest...

I'm active on other sites too. Below are my latest thirty "tweets" and links and photos from around the web.

  • icon Tweet @ 10:28PM Feb 11, 2012

    RT @nitya: Great @gigaom article on rethinking AdMeter solutions.. How social media is making polling obsolete http://t.co/cNXp5OsR via ...

  • icon Tweet @ 04:44PM Feb 11, 2012

    embedding works for me, @mistersugar. Perhaps your blog software is stripping out some of the JavaScript or HTML code?

  • icon Blog @ 04:42PM Feb 11, 2012

    Title: The meaning on the Facebook like button

  • icon Tweet @ 09:42AM Feb 11, 2012

    RT @TomJessiman: My coworker, matz http://t.co/g575icZu

  • icon Tweet @ 08:13AM Feb 11, 2012

    t @gigaom article on rethinking AdMeter solutions.. How social media is making polling obsolete http://t.co/cNXp5OsR via @zite

  • icon Tweet @ 01:15AM Feb 11, 2012

    atholic Church blasts contraception & ignores its current child sexual abuse scandal | Manhattan Diary | IrishCentral http://t.co/Fn1de6D6

  • icon Tweet @ 07:07PM Feb 10, 2012

    and: Trick question: 'Are all Google employees stupid?' >> http://t.co/zxRrYY5m

  • icon Tweet @ 05:15PM Feb 10, 2012

    pixies!

  • icon Tweet @ 04:44PM Feb 10, 2012

    w Chrome joins the party with some "Harmony": let, collections, weak maps, proxies, and more http://t.co/GDkl8b06

  • icon Tweet @ 01:43PM Feb 10, 2012

    thrilled about a couple of cool new projects that we just kicked off at #Wayin

  • icon Tweet @ 11:33AM Feb 10, 2012

    RT @spericas: The JAX-RS 2.0 draft specification has been updated and it's under review until 3/10. Change log appendix in doc. http://t ...

  • icon Tweet @ 06:39AM Feb 10, 2012

    hy I'm Feeling So Hard-Nosed Over the Contraception Affair http://t.co/m5AG7MfN v @AdamSerwer @Kdrum

  • icon Tweet @ 11:07PM Feb 09, 2012

    ery cool use of collapsing cooling tower footage http://t.co/HF9DOyva good marketing here

  • icon Tweet @ 07:45PM Feb 09, 2012

    RT @JSCarroll: screenwriters check this out: . http://t.co/lCIVVyFC

  • icon Tweet @ 12:00PM Feb 09, 2012

    screenwriters check this out: . http://t.co/lCIVVyFC

  • icon Tweet @ 10:15AM Feb 09, 2012

    simpler, webbier approach to Web Intents (and Activities): http://t.co/mgE7ZMRI #webintents #webactivities

  • icon Tweet @ 08:56AM Feb 09, 2012

    we need to act more like a start-up | http://t.co/Lz0tqHIi

  • icon Tweet @ 08:50AM Feb 09, 2012

    RT @sogrady: in case anyone missed them yesterday, the @redmonk feb programming language rankings: http://t.co/qOYDKoBh

  • icon Blog @ 08:48AM Feb 09, 2012

    Title: HTML5 Microdata and Schema.org

  • icon Tweet @ 05:04PM Feb 08, 2012

    Every time I see pics of Amsterdam, I miss it so hard. This one is via @reddit: http://t.co/akTwHPqc

  • icon Tweet @ 04:46PM Feb 08, 2012

    RT @filmbabble: Upcoming Cinema Overdrive, Cool Classics & James Bond Originals at the Colony Theater - http://t.co/rMzXTU8m

  • icon Tweet @ 03:51PM Feb 07, 2012

    RT @hodgman: Prop 8 served no purpose, and had no effect, other than to lessen the status and human dignity..." http://t.co/UWtuqMEa #fb

  • icon Tweet @ 01:38PM Feb 07, 2012

    Phys Ed: Exercise as Housecleaning for the Body - http://t.co/vrxIOfyX http://t.co/lludZJkk

  • icon Tweet @ 10:27AM Feb 07, 2012

    RT @ronallo: My article on #microdata and #schemaorg now in the #code4lib Journal. HTML5 Microdata and Schema.org: http://t.co/YcFcprNu

  • icon Tweet @ 09:22PM Feb 05, 2012

    RT @SnootyMonkey: Somebody managed to post his Tweets to Google+, but he landed a man on the moon first as a warmup. Ridiculous! http:// ...

  • icon Tweet @ 06:32PM Feb 05, 2012

    Wayin on your favorite Super Bowl ads in the live event | http://t.co/gij20U1J

  • icon Tweet @ 06:31PM Feb 05, 2012

    watching the Super Bowl and watching the servers

  • icon Tweet @ 12:16PM Feb 05, 2012

    far as I can tell, clicking the Facebook "Like" button means "please spam me endlessly"

  • icon Tweet @ 11:41AM Feb 05, 2012

    Scoble says open web is done... stick a fork in it | http://t.co/Hgjf8lR4

  • icon Tweet @ 11:27AM Feb 05, 2012

    one of the great joys of parenting is relearning basic math and algebra… NOT

Apache feather

Powered by Apache Roller