I haven't tried storing data in a custom property as yet, but wouldn't that render the same lack of performance behavior, where putting the data into a stack of the UI?
Mark Stuart masmit wrote: > > Mark, you might store the data from the database in a custom property > of the table field, and only show as much data as will fit in the > field at it's current size. > > You'd have to write your own scrolling routines to update the > display, but it can be done. > > Best, > > Mark > > On 21 Feb 2008, at 19:04, mfstuart wrote: > >> >> Hi All, >> >> I have a question about large data sets (thousands of lines) in a >> table >> object and the slowing down of the UI performance, especially on >> resizing >> the stack. >> >> My application interfaces to an MS SQL 2000 database via ODBC. No >> problem >> there. >> The SQL table I have has over half a million records in it, and >> this grows >> all the time. >> >> Potentially, the user could return all records, which would take a >> while to >> load them all. >> But I've created the interface to allow the user to return a >> smaller record >> set. This can be alot of records - 10, 30, 40, 50000 thousand or >> more, or >> just a few hundred. It depends on how the user searches the database. >> >> Now when large record sets are returned from a search, the UI (user >> interface) slows down, especially when resizing the stack to see more >> records in the table object. When resizing with no records, the UI is >> performs normally with fast resizing. >> >> Q: has any one seen this before? And if so, how do you handle the >> drop in UI >> performance? >> >> Thanx, >> Mark Stuart >> -- >> View this message in context: http://www.nabble.com/UI-performance- >> and-large-data-set-in-Table-Object-tp15618647p15618647.html >> Sent from the Revolution - User mailing list archive at Nabble.com. >> >> _______________________________________________ >> use-revolution mailing list >> use-revolution@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-revolution > > _______________________________________________ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/UI-performance-and-large-data-set-in-Table-Object-tp15618647p15622814.html Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution