MySQL table performance optimization

Closed

I am running an ecommerce site and some tables need optimization as I think they are slow and can be improved with some MySQL index and etc optimization.

A member table (approx 10 columns)

Orders table (approx 30 columns)

Attached is the .sql file with table structure. You will get them with data once the project is awarded.

Skills: MySQL

See more: table optimization, mysql performance optimization, table data structure, index data structure, mysql index, index file data structure, mysql slow, Performance Optimization, mysql optimization project, ecommerce sql table, performance slow, mysql load file sql file, mysql data optimization, optimization mysql, data mysql table, table structure, sql optimization, data optimization sql, insert data table using xml file sql server, mysql columns, xml file sql table vbnet, import csv file sql table, conver xml sql table mysql, import text file sql table, mysql sql file

Project ID: #5020002

13 freelancers are bidding on average $29 for this job

bgeorge

I can help you with this project in no time. I'm very good with mysql and php and also with web services if you need to implement them.

$25 USD in 1 day
(216 Reviews)
6.1
kchg

Hello, sir I'm interested with your project. I'll do it for you. I can do it well more than you can think. :) Regards.

$53 USD in 1 day
(56 Reviews)
5.6
bdsitech

Hi, I have completed 100+ projects with PHP & MySQL.I have long time experience to work on website and its development using PHP/MySQL.You can check my feedback records. If you award me this project I can perform all More

$35 USD in 3 days
(29 Reviews)
4.7
harsh170890

Hello There We can optimize both the tables and we will use some particular sql queries. Let me when to start. Ready to start.

$33 USD in 0 days
(7 Reviews)
4.6
tlchung

sql expert here, i can tune the sql for you, and create necessary index for your tables. let start now..

$24 USD in 2 days
(21 Reviews)
4.2
thetidevw

Hei, jeg kan hjelpe deg, har gjort mye optimisasjon i mysql database. i can help you and start asap! i have lived i Bergen for 14 years, thats is why i speak norowegian. Any questions let me know my friend!

$31 USD in 1 day
(13 Reviews)
4.1
parthuji

Quality work assuredQuality work assuredQuality work assuredQuality work assuredQuality work assuredQuality work assuredQuality work assuredQuality work assuredQuality work assuredQuality work assuredQuality work assur More

$25 USD in 3 days
(4 Reviews)
3.8
CodeRaiser

Hello! What makes you think it has to be optimized? Do you have any slow queries log or something? Regards Vlad

$25 USD in 3 days
(8 Reviews)
3.6
scripish

Hi, I am a professional Software engineer and I recently joined freelancer, if you could give an opprotunity to me, I will give a good solution Thanks

$25 USD in 3 days
(0 Reviews)
0.0
vivekagarwal22

Hello Sir, I have 4+ years of experience in SQL Server and can fix the issues. I understand your requirements and can guarantee you quality work in estimated time. Thanks, Sunil Agarwal

$22 USD in 2 days
(0 Reviews)
0.0
sdldotnet

I am specialist in .NET, Crystal Reports, SSRS and My SQL, SQL Server 2005/2008, I am more interested to do this project, few details about me: I possess a Master`s degree in Information Technology with a major in In More

$29 USD in 1 day
(0 Reviews)
0.0
juanjosecs

Hi, I have experience working as DBA, so, I've saw tuning tables in SQL Server, DB2, etc. I would like see your e-commerce to know where we should apply change in your databases. Tell me more about your projects.

$25 USD in 3 days
(0 Reviews)
0.0
rahuljha4k

becz i love the work on mysql and i create more than thousand table. so i think this project enjoyable for me and

$25 USD in 3 days
(0 Reviews)
0.0