time processing with data grid form

Trevor DeVore lists at mangomultimedia.com
Thu Oct 29 13:04:29 EDT 2009


On Oct 27, 2009, at 11:48 AM, mario rossi wrote:

> I am using a datagrid form with a query from a db.
>
> The query result is about 10000 records.
>
> Each line in the form has an arrow which you can click to expand the  
> line and to read other information about the record (with another  
> query).
>
> If I set the dgProp[fixed row height] to false (to expand the row)  
> the time necessary to populate the datagrid is greater than the  
> dgProp[fixed row height] is true. However it takes always a lot of  
> time.
>
> Is there another solution to populate the datagrid?
>
> (I tried to use the cursor db and the technique to display large  
> amount of data described in bluemango manual, but the result doesn't  
> change)

Hi Francesco,

Trying to draw 10,000 records with "fixe row height" set to false is  
going to be a slow process. The Data Grid has to go through every  
single row and determine what the height is before rendering.

You mention that with "fixed row height" set to true it still takes a  
while. By chance do you have "persistent data" checked in the  
properties panel? If so then turn it off. The Data Grid will store all  
10,000 rows in a custom prop of the data grid if this is true and that  
can be slow.

Let me know how this goes. Once you can get initial population of the  
Data Grid to an acceptable level then I can show you some tricks for  
speeding things up when "fixed row height" = false.

-- 
Trevor DeVore
Blue Mango Learning Systems
ScreenSteps: http://www.screensteps.com
Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.com



More information about the use-livecode mailing list