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).

Here is some more information:

I am using the latest ADO.Net mySQL driver.

The mySQL database is installed on a Laptop with a 2GHz Intel Centrino CPU, 512MB RAM. I understand that I could upgrade the hardware but I should get much better performance than I already have with the hardware I am using?

Habilidades: .NET

Ver mais: visual studio job, simple file database, reccomend, need sql developer, mysql developer source code, mysql developer job, my sql developer, daily item, bills materials mysql database, mssql optimisation, optimization mssql database, sql less than, on sql, ms visual studio, sql, sql project , sql mysql, SQL DEVELOPER, Sql code, sql c, optimisation, mysql database , export mysql, document database, database sql

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

ID do Projeto: #134996

11 freelancers are bidding on average $64 for this job


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)