Recently, most DBMS have a bulk insert mechanism instead of each transaction. Check it.
-Edward On Thu, Aug 28, 2008 at 6:27 AM, Yih Sun Khoo <[EMAIL PROTECTED]> wrote: > Optimizations > > > > Right now I have a job whose reducer phase outputs the key-value pairs as > records into a database. Is this the best way to be loading the > database? What > are some alternatives? > -- Best regards, Edward J. Yoon [EMAIL PROTECTED] http://blog.udanax.org