John Kaster

Behind the Screen

QC Login performance problems resolved

with 3 comments

QualityCentral has recently been having very slow logins. Fortunately, we just discovered the culprit and have resolved the performance problems through the use of an internally-developed test framework we’ve implemented for EDN systems to track stability and performance.

It was an embarrassingly simple mistake – we were missing an index on the USER_ID column in one of our tables. Adding the missing index brought the query time down from over 27 seconds (on average) to 31ms on average. Now, the QC windows and browser clients are finally logging in again like they used to.

As the users in the database grew, the server was performing a natural scan on the table, and naturally this was taking longer and longer to complete. Now that the index is in place, the query should now provide reasonably consistent performance even as the dataset grows.

My apologies for missing this performance improvement for so long. I’d like to thank Sriram Balasubramanian for noticing the performance problem when he was reviewing our EDN performance test suite for InterBase.

I’m just glad to finally put that annoying performance issue behind us!

Advertisements

Written by John Kaster

November 15, 2010 at 12:07 pm

3 Responses

Subscribe to comments with RSS.

  1. > from over 27 seconds (on average) to 31ms on average.
    Thank you.

    Tomohiro Takahashi

    November 15, 2010 at 10:00 pm

  2. Is QC#89343 resolved by the fix?

    Tomohiro Takahashi

    November 15, 2010 at 10:15 pm

  3. @Tomohiro-san, Yes, QC#89343 is resolved. Thanks for the reminder.

    John Kaster

    November 16, 2010 at 12:13 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: