OK. I was thrown by three things you said, “subgroups”, “dataGrid” and “query”
I now know you built your gadget from scratch, assume there is no SQL stuff going on, and that you have a lot of groups. So I made a card with 2000 groups, each with a checkBox and six fields. I populated all the fields with random data. I then duplicated the card. That took a little while. Without changing anything on either card, it takes 7 seconds to navigate from one to the other. Again no changes. This is on a Mac Mini, M2 a fairly fast machine. LC was never good at this, navigating either within a stack with many thousands of cards, or from card to card where each card is heavily populated. But what is odd is that I never changed the contents of either card, simply navigating back and forth and each time got a reliable 7 second transition time. How are you getting instantaneous navigation after fooling around with the data??? Craig, > On May 12, 2026, at 12:24 PM, jbv via use-livecode > <[email protected]> wrote: > > Le 2026-05-12 11:12, Bob Sneidar via use-livecode a écrit : >> Are you updating the datagrid using setDataOfIndex? If so, then I believe it >> updates all the data, not just the visible data as it does when the datagrid >> updates automatically. Also, are you doing a query of the data each time the >> card changes? >> Bob S > > As I said, I've built a custom datagrid, so I can't use the regular datagrid > commands. > Before each query, all the fields are emptied, and then, depending on the > number of > results of the query, only one row (6 fields) can be filled, or up to 1800 > rows > (10800 fields). > Emptying the fields and then inserting new contents is pretty fast, even for > sucessive > queries on the same card. The only problem is the delay when going to the > next card. > I might be wrong, but I have the impression that the engine is storing the > content of > the card somewhere before switching to the next card, for faster display when > returning > to the first card. > I am using LC Community 9.6.2 on Mac OS Cataline 10.15.8. > > Best, > jbv > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
