ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <lmead...@apache.org>
Subject Re: batch insert
Date Fri, 25 Nov 2005 13:48:38 GMT
1,000,000 records?!?

Use your database's bulk load tool.

Larry


On 11/25/05, 丁睿 <dingrui001@paic.com.cn> wrote:
>
>
>
>
>  My problem is how to upload 1,000,000 record?
>
>
>  I user spring framwork.
>
>  DAO:
>         for (int i = 0; i < list.size(); i++) {
>                 getSqlMapClientTemplate().insert("createPrem",(PremDTO) list.get(i));
>         }
>
> in sql_mapping.xml
>
>
>
> It's so slow, any body have better good idea to solve this problem
>
>
>         <insert id="createPrem" parameterClass="com.paic.file.dto.PremDTO">
>         INSERT INTO FILE_UPLOAD
>                         (CONFIRM_DATE,
>                                 PLAN_CODE,
>                                 PLAN_NAME,
>                                 ACCOUNT)
>                 VALUES (#confirmDate#,
>                                 #planCode#,
>                                 #planName#,
>                                 #account#)
>     </insert>
>
>
> THX a lot!
>
>
>
>
> ********************************************************************************************************************************
> The information in this email is confidential and may be legally privileged. If you have
received this email in error or are
> not the intended recipient, please immediately notify the sender and delete this message
from your computer. Any use, distribution,
> or copying of this email other than by the intended recipient is strictly prohibited.
All messages sent to and from us may be
> monitored to ensure compliance with internal policies and to protect our business.
> Emails are not secure and cannot be guaranteed to be error free as they can be intercepted,
amended, lost or destroyed,
> or contain viruses. Anyone who communicates with us by email is taken to accept these
risks.
>
> 收发邮件者请注意:
> 本邮件含保密信息,若误收本邮件,请务必通知发送人并直接删去,不得使用、传播或复制本邮件。
> 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> ********************************************************************************************************************************
>
Mime
View raw message