# Recommendation for custom sorting of dropdown list dataset? **URL:** \ **Category:** Ignition\ **Tags:** vision, perspective\ **Created:** [December 13, 2022, 7:08pm UTC](https://forum.inductiveautomation.com/t/recommendation-for-custom-sorting-of-dropdown-list-dataset/67574 "2022-12-13T19:08:05Z")\ **Posts on this page:** 1\ **Showing post:** 7
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [December 13, 2022, 11:57pm UTC](https://forum.inductiveautomation.com/t/recommendation-for-custom-sorting-of-dropdown-list-dataset/67574/7 "2022-12-13T23:57:36Z")
I would go with tall. I see no reason to go with a wide format although I am no database expert. Only thing I may add is a "group" id. while you may have only one group now in the future you may need the ability to sort on multiple groups where the same user has multiple groups assigned to them. you could always change later but if you add a group id column now you dont have to worry about that in the future. 6000 rows is nothing for a database table. I think you will have a big complicated mess if you try and do this with a wide table. IMO of course. If you are worried about saving space which isnt a concern imo you could serialize the dataset and store everything in 1 row > [@How to serialize a dataset?](https://forum.inductiveautomation.com/t/how-to-serialize-a-dataset/11567/3): > > Well, I had just figured out how to do it in pure Python by converting the dataset to a list of lists, using the python pickle module to serialize it, base64 encoding it and putting it in the database… but thanks to pturmel I was able to get the Java version working in just a couple minutes. I also referred to this blog post: [joeygibson.com/2003/05/22/jytho … oo-useful/](https://joeygibson.com/2003/05/22/jython-is-just-too-useful/) . So here’s how I got it to work. Database (PSQL) has some character varying fields for identifying the save, and a bytea fiel… --- _[View the full topic](https://forum.inductiveautomation.com/t/recommendation-for-custom-sorting-of-dropdown-list-dataset/67574)._