1,000,000 records?!?
Use your database's bulk load tool.
Larry
On 11/25/05, 丁睿 <[EMAIL PROTECTED]> 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.
>
> 收发邮件者请注意：
> 本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
> 进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
> ********************************************************************************************************************************
>
