I would argue strongly against storing a comma separated list directly in a text (or any textual based) column.
it wreaks havoc on import/exports. You should employ a conversion to something handy, like the # symbol or such before storing as it's not much of a trick to wind and unwind it in runtime On Wednesday, December 21, 2016 at 10:00:01 AM UTC-5, A. Razzak Memon wrote: > > Wednesday, December 21, 2016 > > From The Edge.: Optimizing R:BASE Cloud Applications > Product.......: R:BASE X, R:BASE X Enterprise (Version 10) > Build.........: 10.0.2.11130 or higher www.rupdates.com > Section ......: Multi-User Environment Considerations > Environment...: Microsoft Windows Server 2012R2 > > The ability to fine tune R:BASE itself is one of the many enhancements > added > over the years. Most often, R:BASE is able to make the right decisions > about > the best way to process commands. > > Generally, you know your database and application code better than anyone > else. However, you should always take advantage of the latest enhancements > and syntax, and pick the most efficient method if given the opportunity. > > Did you know that there are four settings that can improve performance in > a multi-user environment with Cloud applications? > > . STATICDB > . ROWLOCKS > . FASTLOCK > . PAGELOCK > > A technical document on Optimizing R:BASE Cloud Applications is now > available. > > From The Edge: http://www.razzak.com/fte > > Article Title: Managing User Privileges in R:BASE X/XE (Version 10) > > Have fun! > > Very Best R:egards, > > Razzak. > > www.rbase.com > www.facebook.com/rbase > -- > 33 years of continuous innovation! > 18 Years of R:BASE Technologies, Inc. making R:BASE what it is today! > -- > > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
