Calvin Correli logo
0

New and improved performance

Other
Oct 06, 2002
by Calvin Correli
1 min read

Bugger. I’ve been annoyed with how slow my front page was for so long, but I never took the time to do something about it. Well, I did just now. Turns out it was one stupid query which took almost 8 seconds to process. All I had to do was create an index. So now it’s back up to tolerable speed. Hooray! :)

Like

About Calvin Correli

I've spent the last 17 years learning, growing, healing, and discovering who I truly am, so that I'm now living every day aligned with my life's purpose.

Read more
Read next

Topology of the internet

2 comments

Jarkko Laine
 

Interesting Could you share some details? <p> Thanks,
Read more
Read less
Reply over 20 years ago
  Cancel
Lars Pind
 

Nothing too interesting I have a stupid table that logs hits to my photos and pages, because I wanted to play around with doing things like "most popular ...", and "people who liked this photo also liked this ..." (ratings). <p> Anyway, the fix was to create an index on the article_id/image_id column (on_what_id) of the table counting hits. Counting those hits for just the 5 most recent articles listed on the front page took about 8 seconds.
Read more
Read less
Reply over 20 years ago
  Cancel

Leave a comment