- Achronos
- |
- Bungie.net Overlord
Tom Achronos
Bungie.net Overlord
twitter: http://twitter.com/Achronos
"I have no words that would do justice to the atrocities you commit to the English language, as well as your continued assaults on the concepts of basic literacy and logical reasoning."
So, the problem was that when I call the stored procedure that returns the topic listing data manually from the SQL dataase console, it returns in the correct order every time. But the code doesn't always get the same order when calling from the database. But as the code doesn't reorder the results anywhere, the problem was somewhere in the database. Definately irritating to debug.
It turns out it relates to something called the query plan for the stored procedure and a bad assumption made by the procedure about the reliability of ordering. Both should be fixed now, so please let me know if you see the problem again. Don't forget to link to the forum that's busted if you see it.
Posted by: elmicker
Sorry to wade in as a clueless newbie, but, if the database is functioning normally, then wouldnt the frontend rendering code be to blame?