Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MySql: what's the most efficient way of adding large numbers of unique records

Posted on 2013-01-11
1
Medium Priority
?
397 Views
Last Modified: 2013-03-15
Hi

I'm using classic asp and MySql.

I'm creating a survey and need to add up to 5,000 unique records at a time with a randomly generated user name and password amongst other things.

Currently I have a classic asp page that loops through and writes each individual record, which works fine for smaller quantities but drags it's heals with larger.

I'm sure there has to be a better way of doing this - can anyone point me in the right direction?

Many thanks

Grant
0
Comment
Question by:Buzby58
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 38767016
you can try Bulk insert
 
and\or mysqldbimport utility
http://dev.mysql.com/doc/workbench/en/mysqldbimport.html

BTW: it is sql server  sub-forum not mysql
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question