Hi Marty, You'll probably get lots of opinions both ways but with several hundred thousand lines of data, I'd go with an SQL database. If nothing else, your data will be available for analysis by other applications, if that matters. Pete
On Thu, Dec 1, 2011 at 9:55 AM, Marty Knapp <martykn...@comcast.net> wrote: > I'm storing a tab-delimited text list in a custom property, with each item > maybe up to 25 characters or so in length and around 12 items per line. > Over time, this could grow to several hundred thousand lines. The data is > displayed in a datagrid. It's working just fine for me at this point, but > is there a limit to how much data you can put into a custom property? Is > there a point at which there will be a performance hit when displaying in a > datagrid? I'm just wondering if I need to start learning about sql for my > data storage for the long haul. > > Thanks for any input you may have. > > Marty Knapp > > ______________________________**_________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode> > > -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
