We have a sample app (see attachment) where we autogenerate 10.000.000 rows in a table. With a partial reload we only want to add 1 row to the table.
We expect that the partial load will be much quicker than the original load (original takes around 21 seconds), but we see it takes still a lot of time (around 14 seconds for 1 row). What do we do wrong? What is your experience with partial loads, is it worth applying it and does it work as expected?
The script:
T1: Load recno() as ID, recno() as Value, 0 as New autogenerate 10000000;
T1: Add only Load *, 1 as New; Load 10000001 as ID, 10000001 as Value autogenerate 1;
