mysql 8 query optimization

I have a data mysql 8 which is the latest version. There is a data table "ip" with 150,000 pieces of data, now we query it, it takes 0.5 seconds, which is unbearable, I want to ask you to help me optimize it. You need to tell me all your steps and how to adjust it.

Навыки: MySQL, Управление базами данных, Программирование баз данных, SQL

О клиенте:
( 6 отзыв(-а, -ов) ) ca, United States

ID проекта: #34113363



Hi Dear ! I have read your requirement. I can do it. I can complete your project on time and within your budget. Skills : PHP/MySQL, Codeigniter, Angular, Html5/css3, Javascript, Jquery, ajax, nodejs, php Previous Больше

$20 USD за 7 дней(-я)
(21 отзывов(-а))

5 фрилансеров(-а) готовы выполнить эту работу в среднем за $52


Hello, I understood your needs, but have few questions, text me and I will clear all my questions right away

$50 USD за 2 дней(-я)
(70 отзывов(-а))

Hey Mate, Database Programming, Database Administration, SQL and MySQL Expert here. I have read your description about mysql 8 query optimization I am ready to start working with you on this project, I have done these Больше

$20 USD за 1 день
(1 отзыв)

Hi There, I went through your requirements and I would like to assure you that I totally understand your requirements and ready to work ASAP. Requirement Details I have 5 years + of experience and a small team with ta Больше

$140 USD за 1 день
(3 отзывов(-а))

Hi, Project- mysql 8 query optimization I am professional developers having 6+ years of working experience. Kindly drop us a massage with your project details and rest you could be assured that your requirements wi Больше

$30 USD за 2 дней(-я)
(0 отзывов(-а))