Are you really sure it would be faster with direct SQL ? Just to get an idea, you can test with a PreparedStatement and a loop to insert 40k records in a table.
Enrique Rodr�guez wrote:
HI Bruce, my config is win2k, castor 0.9.4.1, oracle jdbc drivers, without app server, (it will go on Sun One 7, but now i'm devoloping on my pc, with netbeans3.4.1), I receibe an xml file with near 3500-6000 products. this products have some caracteristics (near 200) and are stored in different tables (near 40), read XML file go very fast, when i read all, i store they in the database. All the products belong to a shop Object, so I only db.create(shop). From this time to the first insert, castor take 3 minutes. to insert near 40000 records on the database takes another 3 minutes. I don't now why castor take the first 3 minutes, and this is my problem. Regards, Enrique. -----Mensaje original----- De: Bruce Snyder [mailto:[EMAIL PROTECTED]] Enviado el: mi�rcoles, 27 de noviembre de 2002 16:35 Para: [EMAIL PROTECTED] Asunto: Re: [castor-dev] Disable transaction This one time, at band camp, Enrique Rodr�guez said: ER>Thank youu Rainer, I don't know if my solution will be disable transaction, ER>but but castor is very slow for me. I am investigating the castor behaviour, ER>becouse it take a lot of time from db.create(myObject) to the first insert ER>on the database. If that's the problem, it sounds like some troubleshooting and tuning of your app is in order. Trying to disable transactions in Castor is a complete sledgehammer approach. Let's get some info about your environment and your app so that we can narrow down the slowness in your app. What operating system, Castor version, database and JDBC drivers are you using? Are you using an app server? If so, which one? What *exactly* is slow in your code (post the relevant section(s))? How slow is it? What types of troubleshooting have you performed so far and what have you found? Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E
--
Mickael Guessant
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
