UI performance and large data set in Table Object
mfstuart at cox.net
Thu Feb 21 18:21:44 EST 2008
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, 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.
> On 21 Feb 2008, at 19:04, mfstuart wrote:
>> Hi All,
>> I have a question about large data sets (thousands of lines) in a
>> object and the slowing down of the UI performance, especially on
>> the stack.
>> My application interfaces to an MS SQL 2000 database via ODBC. No
>> 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
>> Mark Stuart
>> View this message in context: http://www.nabble.com/UI-performance-
>> Sent from the Revolution - User mailing list archive at Nabble.com.
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
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.
More information about the Use-livecode