"fhh" wrote : Can you post the code of your stored procedure? | | 40.000 records in 5-6 seconds is too low. I would expect much better performance. | | Regards | | Felix
here it is the function. Please ignore parameters (i just took one function as example, as you see i generate id's by myself (was lazy to create sequence :)). I use the same table (TUser as in ejb implementation) FUNCTION GETTUSER(traderCode varchar2, userName varchar2) RETURN varchar2 is | rez varchar2(4000); | aaa number(10); | iii number(10); | | begin | select max(id) into aaa from TUser; | FOR iii in (aaa + 1) .. (aaa + 40001) LOOP | insert into TUser (id, userid, username, userdesc) values (iii, 'useridproc', 'usernameproc', 'userdesc'||iii); | END LOOP; | commit; | rez := 'hoho and the bottle of rum'; | return rez; | end; View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039872#4039872 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4039872 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
