Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-01-11
1
Medium Priority
?
404 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
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

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

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

Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

580 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