*Magnify*
    April     ►
SMTWTFS
 
1
2
3
4
5
6
7
8
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Archive RSS
SPONSORED LINKS
Printed from https://www.writing.com/main/books/entry_id/606171-Most-Viewed-Sorting-Returns
Rated: ASR · Book · Writing.Com · #206127
Announcements pertaining to Writing.Com!
#606171 added September 9, 2008 at 2:28am
Restrictions: None
Most Viewed Sorting Returns!
Greets,

In April, a member emailed us noting that our "Most Viewed" sorting was not actually sorting results correctly. Indeed, when we looked into this, we found it was the result of changes we made to increase the site's speed and performance a few months earlier. Unable to find a viable solution at that time, we removed the sorting option until we could make it work right and work fast.

(For those interested in the "technical" reasoning.... Because the view count is updated very often, while the rest of the item's data is not, in our database backend, we moved the "view count" field from the main item table into its own view table. This simple change removed a bunch of system overhead each time an item is viewed on the site... which is often. *Wink*)

We finally devised a way to quickly sum both the old and new view count data and perform a sort on it in a way that doesn't make the item listing sort time unbearably slow. As such, Most Viewed sorting has returned to the item listings!

Enjoy!
~~SM


© Copyright 2008 Writing.Com Support (UN: support at Writing.Com). All rights reserved.
Writing.Com Support has granted Writing.Com, its affiliates and its syndicates non-exclusive rights to display this work.
Log in to Leave Feedback
Username:
Password: <Show>
Not a Member?
Signup right now, for free!
All accounts include:
*Bullet* FREE Email @Writing.Com!
*Bullet* FREE Portfolio Services!
Printed from https://www.writing.com/main/books/entry_id/606171-Most-Viewed-Sorting-Returns