Given I'm creating a rowset with newFromCachedSelection which uses
a callback method (doing a relate one) and has executable methods
(doing various searches, creating variables etc) in the Map, will
the cache be used next time I make a call to the rowset or does
using a callback and executable methods mean it will always access
the database, making caching null & void?
A cached RowSet is still cached, but if there is a callback method it
is loaded into memory row by row instead of using SELECTION TO ARRAY.
My question stems from using Batches created from rowsets and
whether I can actually cache the rowset to make switching batch
pages quicker.
In the current incarnation of RowSets, they cannot be cached between
requests. That is something I will add in the future.
Cached RowSets help only if:
- There is no callback or column expression and Active4D is running
on Client, in which case SELECTION TO ARRAY is potentially faster
than a row by row load of every record.
- You need to iterator over the contents of the RowSet multiple times
within a single request.
Regards,
Aparajita
Victory-Heart Productions
www.aparajitaworld.com
"If you dare to fail, you are bound to succeed."
- Sri Chinmoy | www.srichinmoylibrary.com
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
