On 12/15/06, <b class="gmail_sendername">Martin Beck</b> <<a href="mailto:martin.beck@hpi.uni-potsdam.de">martin.beck@hpi.uni-potsdam.de</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Am Freitag 15 Dezember 2006 17:53 schrieb Benjamin Pollack:<br><br>Thanks, I'll use that. Didn't know with which solution to go. Another issue<br>is, as stated by someone here, the performance. If I insert for example 14000
<br>entries in a batch, the commit is very long (20mins)... Any reason for this?<br></blockquote></div><br>I don't know the reason, but I've had the same problem. Two years ago in college I was trying to write a Gmail-style web-based email client, using GOODS for the back-end. Part of the problem was that I wanted full-text search, which requires adding tens of thousands of objects to a collection in one commit on certain occasions. At the time, I eventually hit upon committing the changes in batches as a compromise between long commits and network latency. After some tuning, I think I managed to speed things up about five times or so that way.
<br><br>--Benjamin<br>