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.
收发邮件者请注意：
本邮件含保密信息，若误收本邮件，请务必通知发送人并直接删去，不得使用、传播或复制本邮件。
进出邮件均受到本公司合规监控。邮件可能发生被截留、被修改、丢失、被破坏或包含计算机病毒等不安全情况。
********************************************************************************************************************************
