Optimizing Mysql Query Performance on large table

I need a MySQL query to be optimized for filtering a large table (over 1M records)

I have attached database diagram and two queries ( both queries do the same job)

MySQL 5.7 is currently taking around 7 seconds to complete first query, 13 seconds to complete 2nd query (on a normal ubuntu pc )

Please find the database sample used via following link:

[url removed, login to view]

You can change the database structure according to your needs, add remove indexes, re-write the query everything is allowed (except caching) the goal is to get the results under 100ms without caching results. (you can use SQL_NO_CACHE on your queries while testing)

Compétences : Big Data Sales, Développement de bases de données, Programmation de bases de données, MySQL, SQL

en voir plus : software write mq4, query mysql table based date, mysql move large table, software write chip epson, useful software write book, design query large table access, demo aspnet page query mysql table, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, query mysql con ajax, parent child query mysql, table drop php mysql, remote query mysql, bash script query mysql database, insert table lost connection mysql server query, create update query mysql

Concernant l'employeur :
( 1 commentaire ) Milano, Italy

Nº du projet : #12715346

Décerné à:


Hi! I have 10+ years of web developing experience, I can promise quality and responsibility. We can start immediately. Your table is not so big, so it is possible to do these query work fast

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(38 Commentaires)

9 freelance font une offre moyenne de $184 pour ce travail


Dear sir, At first we like to say that we are expert and had more than 10 years experienced in programming languages ( php & mysql, ajax, JS, curl ) We can do your project work as per your requirements sir you will get Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(34 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)

Hello, Hope You are doing well. ARITY INFOWAY is complete web based solutions company. We able to provide web solutions from scratch to hosting . We always go through every point of your projects scope and prov Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(20 Commentaires)

Hi, I can help you to optimize the two queries. I've done similar kinds of work and I've lots of expertise in databases. Contact me for quality work and quick services. Thanks!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(7 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Hi, As per your requirement to optimize database, I would like to offer my services. With my expertise and long term experience, I can guarantee an extraordinary result in less time and fewer expenses. I hav Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

I am specialized in your requirements. In fact, that is what I love to do every day. I am not running the mill of upwork contractors, I am one step solution for you. Here is one of recent wp sites representing my skil Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)