Our installation is using CocoBase 4.5 tied to an Oracle 9.i database running under iPlanet 6.5 application server.

One of your replies to a previous posting suggested using batch inserts/updates to improve performance where large volumes of data is to be updated in a single transaction (invoked from a web page). Is this available for 4.5 and if so, can you please provide a link to the appropriate documentation on how this is implemented? It would be appreciated.

If you're on the latest SR8 of CocoBase 4.5, yes it supports batch inserts/updates and deletes. To confirm the version of CocoBase you are using, the %coco_home%\version.txt file will provide you with the specific details.

Both the lower level CocoPowder* classes and the CBFacade have properties you can set to enable these features. We'll assume you're using the CBFacade, in which case you would add the batch features you need such as:

...
cbfprops.put("cocosource.batchinsert", "true");
cbfprops.put("cocosource.batchupdate", "true");
cbfprops.put("cocosource.batchdelete", "true");
...

Then you connect to the CBFacade using these and the rest of your connect properties. The rest is automatically handled by CocoBase.

We hope this answers your question.

THOUGHT Support