FromJournalScapeHQ Announcements from the folks at JournalScape |
||
:: HOME :: EMAIL :: | ||
Read/Post Comments (0) |
2003-09-10 9:13 PM 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 |
© 2001-2010 JournalScape.com. All rights reserved. All content rights reserved by the author. custsupport@journalscape.com |