İptal Edildi

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?

Beceriler: .NET

Daha fazlasını görün: 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

İşveren Hakkında:
( 8 değerlendirme ) Poole, United Kingdom

Proje NO: #134996

11 freelancer bu iş için ortalamada 64$ teklif veriyor

meetesh

plz check my PMB

1 gün içinde 100$ USD
(71 Değerlendirme)
8.1
bewhite

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

in 0 gün içinde30$ USD
(6 Değerlendirme)
5.8
TakeReal

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

in 3 gün içinde100$ USD
(228 Değerlendirme)
5.8
LanceGuru

Hi, please check PMB. Thank you.

1 gün içinde 50$ USD
(4 Değerlendirme)
4.0
specialtyshack

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

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0
EricLee

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

in 0 gün içinde35$ USD
(0 Değerlendirme)
0.0
ittehadjordan

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

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
asharsh

I can do this.

in 2 gün içinde60$ USD
(0 Değerlendirme)
0.0
Prakshal

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.

1 gün içinde 75$ USD
(0 Değerlendirme)
0.0
bestdev

we have .net professional team

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
templecitytech

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 Daha fazlası

1 gün içinde 90$ USD
(0 Değerlendirme)
0.0