I found that when going to the database approach and directly feeding the database you are limited to a fixed row height datagrid.
-= Mike Sent from my BlackBerry device on the Rogers Wireless Network -----Original Message----- From: Pete <p...@mollysrevenge.com> Sender: use-livecode-boun...@lists.runrev.com Date: Thu, 1 Dec 2011 10:23:44 To: How to use LiveCode<use-livecode@lists.runrev.com> Reply-To: How to use LiveCode <use-livecode@lists.runrev.com> Subject: Re: Custom Property Data Limit? 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 _______________________________________________ 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