Closed

Database Optimization

We have a platform based in PHP and MySQL on AWS, the app generate intensive SQL selects to generate reports. We need to optimize it at least in the code side, database structure (indexes, etc) and MySQL tuning.

Database facts:

- SQL to review: 30 approx.

- Tables to review: 15 approx.

- 2,7 GB

Skills: MySQL

See more: bus reservation system database structure, database structure plane reservation system, 2008 database sample project code download, php, mysql, website testing, adobe photoshop joomla structure database, understanding word press database structure, vehicle log database structure, openemm database structure, wikipedia database structure, php multi language database structure, simply accounting database structure, facebook app database structure, wikimedia database structure, oscommerce database structure, facebook database structure, tree database structure parent, webapplication database, database teachers

About the Employer:
( 3 reviews ) Santiago de Chile, Chile

Project ID: #10892626

24 freelancers are bidding on average $167 for this job

TakeReal

Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I can help you as SQL guru to speed up slow SQL. Also I can check PHP code (where reports generated) and speed up it too. Yes, I plan to chec More

$250 USD in 5 days
(1090 Reviews)
7.5
zMinion

Hello, I can help you with this project, I have the necessary experience and I can assure you that our collaboration will bring good results. Best regards, Andrei

$150 USD in 5 days
(31 Reviews)
5.4
vinaysinghh

I am mysql dba having more then 6 yrs of experience and I have optimized many mysql database with good result. Please check my review

$111 USD in 1 day
(40 Reviews)
4.9
dimuthufr

Dear Sir I have experienced in web application development using ajax, php And mysql . and also have a experience with android application development With java and standalone app development in java. I take gr More

$100 USD in 3 days
(6 Reviews)
3.9
davedcb

Hello, I am interested in your project. I am a software engineer and I have professional experience with MySQL. Thank you, Best regards, David

$100 USD in 5 days
(18 Reviews)
3.5
johnosullivan

A proposal has not yet been provided

$250 USD in 5 days
(4 Reviews)
3.2
joshuaburns

Hi, In my current Professional Microsoft Senior SQL Server DBA role, I have extensive experience with SQL Server versions 2000-2016. I have immense experience working in SQL Server Development on a daily basis for More

$155 USD in 3 days
(6 Reviews)
3.2
palak17

We are having an experience of 2 years and also provide surety of quality [login to view URL] are also having the team with innovative & creative ideas and good experienced in Google Analytic s and Internet Marketing and Web and G More

$77 USD in 5 days
(4 Reviews)
1.8
iridescent2x15

i am software engineer.I have read the description and i would like to work for you.I can complete your task in [login to view URL] further details please inbox me. Thank you.

$250 USD in 3 days
(0 Reviews)
0.0
elasys63

I am a fast and efficient programmer with a wide array of skills to provide the utmost of quality to my clients

$155 USD in 3 days
(0 Reviews)
0.0
vw7324549vw

I am very good at database and database objects optimization. Handled multiple performance issues in OLTP,production, reports and OLAP dabases.

$155 USD in 3 days
(0 Reviews)
0.0
fsistemas

Hello it is my proposal 1. I want to know which is the slowest query, what are the tables involved. 2. Can you send me create table statements for each table in the query (Step 1) 3. Send me rows in each table(Ste More

$111 USD in 3 days
(0 Reviews)
0.0
joseperales

Hi I am new here in freelancer so I hace a lot experience and also I need to work from my Home, I like the SPEED and really one thing in the web is the Db Querys and the optimization can bring over 30% to 40% of spee More

$155 USD in 3 days
(0 Reviews)
0.0
$245 USD in 3 days
(0 Reviews)
0.0
pvassiliou100

Hello, I have more than 5 years of experience in extracting data from MySQL databases for reporting, optimizing complex queries (joining >5 tables, with 100k-10mil rows each) , transforming the data and exporting th More

$222 USD in 3 days
(0 Reviews)
0.0
nanusrithi

1. Need to check all the tables. 2. Need to verify Primary/Secondary Indexes on all the tables & analyse. 3. Need to check if any partition helps or already exists.

$222 USD in 3 days
(0 Reviews)
0.0
$184 USD in 3 days
(0 Reviews)
0.0
RupsInfotech

Hello sir/mam, We have good experience of PHP,JOOMLA,HTML,HTML5,CSS, Ajax,jquesry,JavaScript,Mysql,Graphic Design,Website Design, Android, mobile application, windows, Photoshop, Banner Design ,Flayer mail,Logo Desi More

$222 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
jaideepsai26

I am working in an MNC in data warehousing domain with SQL as my primary skills.I am new to freelancing and am interested to prove my skills

$35 USD in 5 days
(0 Reviews)
0.0