User 8688ffe688
18-02-2014 20:07:17
Would be nice to have /*+ append */ option for Oracle to increase import performance for JChemManager. This would allow for no logging (no rollback) which dramatically increases performance and reduces the need for rollback storage space for large data loads.
ChemAxon d4fff15f08
19-02-2014 11:38:11
Hi,
Thank you for the idea! It is implemented, will be available from our next release.
Best regards,
Norbert
ChemAxon d4fff15f08
27-02-2014 16:36:01
Hi,
We have implemented the feature and reverted it in short time. The main reasons were:
- up to our measurements it did not speed up the insert/import procedure significantly
- with our present workflow the option would have allowed only one insert inside a transaction, the second would throw an exception
- the option would have locked the whole table for other connections. This can hurt some users in some use cases.
- the option would have been only supported in special circumstances, e.g. all triggers have to be turned off for the table. This is not supported by Jchem Base yet. Of course it is possible to turn off the trigger manually, but that would be uncomfortable for several users.
I hope we did not disappoint you with this decision.
Best regards,
Norbert