TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Thilan
NA
34
0
Check Duplicate Records
Sep 24 2008 5:49 AM
Hi All,
I have a my sql database with 300000 records, Every month I need to insert 50000 records to database.
The way I have done this is,
I have put select comand and it is check thoes 50000 records one by one with 300000 records and if the duplicate not found it is insert to database.
above way it is takin 12 hours to complete the task, This is not under requirement.
I need avoid this much time take for this matter, and If i can do this with in 2 or 3 hours It will be grate.
Please help me someone
Reply
Answers (
2
)
Pass function as parameter.
create public folder on exchange 2003