maemo.org - Talk - View Single Post - What's the problem in Nokia!? People is not working as a team!!

	juise-	2010-06-15 , 22:21
	Posts: 186 \| Thanked: 192 times \| Joined on Jan 2010 @ Finland	#43

Originally Posted by Helmuth

essentials and fundamentals in Database desing: NEVER EVER SORT BY ID! Use a ID only to IDENTIFY a Recordset, sort by something else, never by the ID

I end up doing database design every once in a while, so I'm actually interested if you have a good reason for this?

Or did you perhaps mean NEVER EVER in user interface?

I often end up using id as secondary sort term, I find it a practical way to make sure that the order of items is consistent across queries when primary sort term happens to be same...

__________________
Trout have underwater weapons.

Quote & Reply |

The Following User Says Thank You to juise- For This Useful Post:
Helmuth