En cours

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, Développement de bases de données, Programmation de bases de données, MySQL, SQL

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é à :

alexgospodarets

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

120 $ USD en 1 jour
(36 Commentaires)
5.9

10 freelance ont fait une offre moyenne de 181 $ pour ce travail

itcslive

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

250 $ USD en 5 jours
(34 Commentaires)
6.9
100 $ USD en 3 jours
(8 Commentaires)
5.3
arityinfoway

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

168 $ USD en 5 jours
(20 Commentaires)
5.1
saad2038

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!

200 $ USD en 2 jours
(7 Commentaires)
3.3
277 $ USD en 3 jours
(0 Commentaires)
0.0
techitec

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

166 $ USD en 5 jours
(0 Commentaires)
0.0
BestInfovision

Dear Client, I am Suraj “.NET Developer & Software Consultant”. Having 11 Yrs. of Experience. Portfolio [url removed, login to view] General Portfolio [url removed, login to view] Plus

155 $ USD en 5 jours
(0 Commentaires)
0.0
155 $ USD en 3 jours
(0 Commentaires)
0.0
shaber83ahmed

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

222 $ USD en 5 jours
(0 Commentaires)
0.0