but the time between db.create and the first insert???? is the half time of all the operation��
-----Mensaje original-----
De: Micka�l Guessant [mailto:[EMAIL PROTECTED]]
Enviado el: mi�rcoles, 27 de noviembre de 2002 19:20
Para: [EMAIL PROTECTED]
Asunto: Re: [castor-dev] Disable transaction
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
