I was wondering if there is a more efficient way to handle large multi-record inserts. For example in Oracle I can bulk load data from ProC using an array of C Structure with one insert statement like this:
INSERT INTO SSJ
Where tmp_ssj_data is an array (100s or 1000s) of structured records corresponding a table's column values. This greatly enhances performance for large data inserts.
Is there any way in Cloudscape to do something similar? I am already aware of importing from a file. But I am looking for something that I can run from a Java app using an array of object records that doesn't require dumping to and reading from a file. That wouldn't seem to buy much in terms of performance.
Any thought on the matter or experience with larger data inserts appreciated.