You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Graham Lounder <lo...@caris.com> on 2003/01/13 21:56:14 UTC

Large Collection of Insert Statements

Hey all,

I'm working on a project where there is a "scratch pad" of search results.
This means that there is a persistent list of search results in the database
at all times, so each row in the search results executes an insert/update
statement.

The problem occurs when a search results with 5000+ records takes about 1
minute to execute (aka 5000+ insert/update statements).  This may be more of
a database question but how can I do this efficiently?  Is there some way to
update a collection of objects quickly in OJB?

Any Ideas?
Graham

============================================
  Graham Lounder
  CARIS - Spatial Components Division
  264 Rookwood Ave
  Fredericton NB E3B-2M2
  Office 506 462-4263
  Fax    506 459-3849
  http://www.spatialcomponents.com
============================================
  CARIS 2003 - Gateways in Geomatics
  November 18-21, 2003, St. Louis, Missouri, USA
  Join us in St. Louis, the Gateway to the
  West, to explore Gateways in Geomatics.
  Vist www.caris.com/caris2003 or e-mail caris2003@caris.com for more.
============================================