UI performance and large data set in Table Object

mfstuart 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 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 at 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 at 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.




More information about the use-livecode mailing list