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?
11 freelancers are bidding on average $64 for this job
I can give you several recommendations about your system optimisation. Thanks.
Please, show me database and source code. If you want to choose my bid - escrow deposit is required, please.
I have the expericence and ability to do your job. It only needs several hours.
We have Data warehousing experience so tuning up a small database is walk in the wind.
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.
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 Fazla