FromJournalScapeHQ
Announcements from the folks at JournalScape

Previous Entry :: Next Entry

Read/Post Comments (0)
Share on Facebook



Geek Improvement: Faster Entry vs Comment Queries

This upgrade is probably only interesting to the geeks in the crowd.

The SQL queries used to fetch entry lists, along with comment counts for each entry, were growing slower and performing too many comparisons to be scalable. All of the columns involved were properly defined as keys it was just the nature of the query that caused it to grow multiplicatively.

We have added a new field in the entry table to keep a running total of the comment counts so we don't need to do cross table counting and comparison. This has reduced the number of comparisons greatly.


Read/Post Comments (0)

Previous Entry :: Next Entry

Back to Top

Powered by JournalScape © 2001-2010 JournalScape.com. All rights reserved.
All content rights reserved by the author.
custsupport@journalscape.com