ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Pannell <steven.pann...@zooplus.com>
Subject Bulk inserts
Date Thu, 03 Nov 2005 06:57:10 GMT
Hi,

Is there a faster way of performing bulk inserts?

currently I do something like:


for(int i=1;i < list.size(); i++) {

	MyObject object = list.get(i);
	sqlMapClient.insert("myInsert", object);

}


This seems to take forever!  Is is possible to pass the complete list or
something to save on parsing the statement and getting releasing the
connection for every insert statement??

thx.
Steve.



Mime
View raw message