Re: [RBASE-L] - Re: From The Edge: Optimizing R:BASE Cloud Applications

[Steve Johnson]

Thanks for expanding on the topic, I believe the list has answered my question. Best to all. Steve BlackBerry Z30 From: Stephen Markson Sent: Thursday, December 22, 2016 11:21 AM To: rbase-l@googlegroups.com Reply To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Re: From The Edge: Optimizing R:BASE Cloud Applications We import and export text with embedded commas all the time. There is absolutely no problem as long as you set it up correctly.     Regards,   Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251   From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Michael Byerley Sent: December-22-16 10:43 AM To: RBASE-L Cc: raz...@rbase.com Subject: [RBASE-L] - Re: From The Edge: Optimizing R:BASE Cloud Applications       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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.