Originally Posted by asokram
Donot use the simple clone record. Instead write a script in the below process.
Select the current record.
Copy the individual field values to variable
Create a new recod
Apply the variables to each field of the new record
In this way you have more control on your records.
I have created a script that asks for the number of copies to be created
of a record, and then all fields of the selected record are stored in each own variable (The form has 22 simple rel.fields, 2 m2m rel.fields, and 13 text based fields). Then I have a FOR loop that creates all the new records, and I have
a record set variable collecting all record numbers of the new records (BOOLEAN record set).
Then I have another FOR loop which changes all the fields of the new records,
based on the fields copied from the original record, and the record set variable
created in the first FOR loop.
It works, but its incredibly slow. Using the workplace version against the server, running this script, it seems to create the new records reasonably fast, but it takes more than 15 seconds (!) to change the fields of each record, even if Im operating on a record set.
If I run the same script directly on the server, its much faster.
Making 50 copies of the original record is done in about 30 seconds (still kinda slow though).
Are there any tricks or tweaks to speed up the process, or do I have to live with the low speed? Duplicating records this slow is not usable at all.