MS SQL or mySQL Database Optimisation

I have created a project that will convert csv text to a mySQL database.

The mySQL database works fine but now I have 20,000+ items stored my database is very very slow. I need to perform updates on each item in the database daily and takes 4+ hours to complete. I have resorted to use a text file for now as it only takes 4 mins!

I would like you to look at my source code and the mySQL database and reccomend how I would make this much faster, if possible make the changes and document the changes you have made for my reference.

The project is C# using Visual Studio 2005. I will supply the project files and a mySQL export file (please tell me how you prefer this).

This is a very simple job for you and I would expect it to take less than 2 hours (if you are seasoned SQL developer).

Habilidades: .NET

Ver mais: visual studio job, simple file database, reccomend, mysql developer source code, mysql developer job, daily item, bills materials mysql database, mssql optimisation, optimization mssql database, sql less, on sql, sql mysql, sql code, sql c, optimisation, mysql database , export mysql, database developer, visual studio mysql, sql created, mysql convert text, visual studio csv, project using sql, convert sql database, simple project using database

Acerca do Empregador:
( 8 comentários ) Poole, United Kingdom

ID do Projeto: #134996

11 freelancers estão ofertando em média $64 para este trabalho


plz check my PMB

$100 USD em 1 dia
(71 Comentários)

I can give you several recommendations about your system optimisation. Thanks.

$30 USD in 0 dias
(6 Comentários)

Please, show me database and source code. If you want to choose my bid - escrow deposit is required, please.

$100 USD in 3 dias
(228 Comentários)

Hi, please check PMB. Thank you.

$50 USD em 1 dia
(4 Comentários)

Hmm. I have a few questions before I can give more help. I'll PM with more.

$100 USD em 1 dia
(0 Comentários)

I have the expericence and ability to do your job. It only needs several hours.

$35 USD in 0 dias
(0 Comentários)

We have Data warehousing experience so tuning up a small database is walk in the wind.

$30 USD in 0 dias
(0 Comentários)

I can do this.

$60 USD in 2 dias
(0 Comentários)

Have gone throuugh your need and requirement. Has full expertise of Database maintainance and optimisation in MS-SQl,My-SQl, Oracle , DB2. so can do the work as per your requirement. loking forward for you reply.

$75 USD em 1 dia
(0 Comentários)

we have .net professional team

$30 USD em 1 dia
(0 Comentários)

We are one among the largest offshore IT Company and extremely interested in taking up this project and aims to deliver you the best of all services. We have gone through your requirements and feel fully confident of e Mais

$90 USD em 1 dia
(0 Comentários)