WTF. A Bug

[Twista]

take a look here Text

 

[PowerMacG5]

http://forums.anandtech.com/messageview.cfm?catid=42&threadid=1170056
http://forums.anandtech.com/messageview.cfm?catid=42&threadid=1170054

 

[Twista]

why the forums being effected now...

 

[RagingBITCH]

End of daylight savings time. It always fubars the forums.

 

[Haircut]

It seems pretty poor to me that the end of daylight savings time can cause the forums to screw like this.

I'm assuming there is an order by post date clause when selecting the threads/messages to display.
To me it makes much more sense to order by the threadid/messageid so that things are displayed in the true order they were created.

The fact that you would by ordering on the primary keys of the respective tables means things should theoretically be (a little) quicker as well because you could take advantage of the unique index.

 

[Jason Clark]

Haircut, fusetalk orders by dates and absolutely has to. Ordering by threadid? That would never work, remember we have to order by the lastmsgdate of a thread since 99% of people want to see the most recently replied to threads not threads that were created and have no activity. Also, the date order is using a clustered index so the index comment has no bearing. Almost EVERY app out there that orders by date will suffer during a time switch over, welcome to daylight savings time people. So it is not "poor design" it is a fact of life, that's all.

Hopefully that sheds light.

 

[awal]

actually if you store times in UTC you would not have this problem....

 

[ViRGE]

I certainly don't mind it, it lets us have some fun for 1 hour every year.🙂

 

[Jason Clark]

Adrian, not interested in it as most of our customers that do custom work prefer having normal dates to run reports on. This is no where near a big deal.

 

[awal]

Originally posted by: Zuni
Adrian, not interested in it as most of our customers that do custom work prefer having normal dates to run reports on. This is no where near a big deal.

I guess it would be more of a pain than anything for a forum... In the healthcare industry the FDA has strict regulations about the timestamps being in a format that indicates the time zone. In that industry UTC is the defacto standard, if you plan to share data with someone in another time zone.

 

[Jason Clark]

Ya.

 

[awal]

Originally posted by: Zuni
Ya.

Zuni, aren't you canadian? Shouldn't that be 'EH'.... 😀

 

[Jason Clark]

LOL, ok Eh sure 🙂

 

[1966]

Originally posted by: ViRGE
I certainly don't mind it, it lets us have some fun for 1 hour every year.🙂

That's twice a year.😉

Spring & fall. 🙂

 

[Aves]

Originally posted by: 1966
That's twice a year.😉

Spring & fall. 🙂

Time goes forward in the Spring so that doesn't have an effect. 🙂