Modify a MySQL insert Perl script so it does batch insert

$10-30 USD

Concluído

Publicado

há aproximadamente 8 anos

$10-30 USD

Pago na entrega

I have a Perl MySQL CSV inserter script that is called from another CGI Perl script with system function. It now loops around a file input's array and inserts to the MySQL database using DBI module and outputs its progress to the browser. I would like it made so that the script will batch / bulk insert like this reference URL: [login to view URL] The attached files are the inserter script you need to modify, and the CSV file used as a test. I would like at least a 5x increase in performance by bulk inserting, but faster the better.

MySQL

Perl

Software Development

ID do Projeto: 10186013

Sobre o projeto

4 propostas

Projeto remoto

Ativo há 8 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@midtask

Heya. After analysis of your perl script I have found that the database is not the choke point. Infact the insertions still perform at the same speed when properly using prepare(). Your original script completed after 15.656 seconds. After removing Text::CSV::Encoded, the script completes in 3.267 seconds (4.7x faster). This also removes the dependency to install the Text::CSV::Encoded module. Condensing in to a single insert statement reduced the speed down to 0.874 seconds (17.9x faster).

$20 USD em 0 dia

5,0

(8 avaliações)

3,1

4 freelancers estão ofertando em média $27 USD for esse trabalho

@gangabass

I'm one of the best Perl developers here that's why I'm sure you'll be impressed with my work. You have two slow parts in your code and I can fix it in less than a day. All I need to start is milestone payment from you. You'll release it after you check everything on your side. Thanks. Roman

$34 USD em 1 dia