mass inserts

[Yuji Shinozaki <ys...@virginia.edu>]

When we do a lot of inserts at once, it seems like OJB does a lot of
"pre-querying".   I think this is for deciding whether a new object
consistutes an UPDATE or an INSERT.   For mass-loading of objects
(which we know will be new unique INSERTS). Is there anything we could do
to optimize the process?  Prevent it from pre-querying?

Will proxies help by quickening the queries?

Any pointers welcome.

yuji
----
Yuji Shinozaki	                        Computer Systems Senior Engineer
ys2n@virginia.edu			Advanced Technologies Group
(804)924-7171				Information Technology & Communication
http://www.people.virginia.edu/~ys2n    University of Virginia

Re: auto_increment problem?

[Armin Waibel <ar...@code-au-lait.de>]

Hi Chuck,

Could you post a little more info.
Which OJB version?
Which sequence manager implementation do you use, or
post your repository_database.xml file (if you use one).

regards,
Armin

----- Original Message -----
From: "Chuck Grohowski" <ch...@hubcitymedia.com>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Monday, March 24, 2003 4:09 PM
Subject: auto_increment problem?


> I noticed a strange anomaly when using OJB with auto_increment fields
in
> MySQL.  After doing a few inserts of new objects, the auto_increment
field
> has values in the hundreds.  Is this behavior normal or is there
something
> going awry?
>
> Any help is appreciated.  Thanks!
>
> Chuck
>
> --------------------------
> Hub City Media, Inc.
> www.hubcitymedia.com
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>

auto_increment problem?

[Chuck Grohowski <ch...@hubcitymedia.com>]

I noticed a strange anomaly when using OJB with auto_increment fields in
MySQL.  After doing a few inserts of new objects, the auto_increment field
has values in the hundreds.  Is this behavior normal or is there something
going awry?

Any help is appreciated.  Thanks!

Chuck

--------------------------
Hub City Media, Inc.
www.hubcitymedia.com