Hi, It is "allways" better for performance to use selection-fields.
The problem is, as you stated, to reorder the content. Before we got the possibility to set our own integer-values it was also a problem to insert values. If you join the two tools ARInside (workflow) with RRR|SelectionChange (data), you can handle the changes without too much of a problem. http://arinside.org https://www.rrr.se/cgi/tools/main#rrrSelectionChange The only thing that is simpler in selection-fields is to rename something. If the values are constantly changing (more than once a year or so), I would suggest that you use something other than selection-values. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > Hello Listers, > ARS 7.1 > MS SQL2005 > > Does anyone have any insight in just when it is best to choose a selection > field over a character field? > The character field would have a menu and the display type would be > Drop-Down List. > > I am asking because time and again I get customers would "never" want to > change the value in the menu/selection field BUT always ask for and > addition, removal, reorder or change of a value. > Anymore I am inclined to only use character fields with menus and reserve > the selection fields for things like "Inactive/Active", "No/Yes", > "False/True", etc. > > Is there a big performance hit using menus? Is it even an issue anymore? > > Thanks, > > > --- > John J. Reiser > Senior Software Development Analyst > Remedy Administrator/Developer > Lockheed Martin - MS2 > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
