Optimizing Mysql Query Performance on large table

$30-250 USD

ที่ทำเสร็จแล้ว

โพสต์

มากกว่า 7 ปีที่ผ่านมา

$30-250 USD

ชำระเงินเมื่อส่งงาน

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: [login to view URL] 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)

รหัสโปรเจกต์: 12715346

เกี่ยวกับโปรเจกต์

9 ข้อเสนอ

โปรเจกต์ระยะไกล

ใช้งานอยู่ 7 ปีที่ผ่านมา

กำลังมองหาการสร้างรายได้ใช่ไหม?

ที่อยู่อีเมล

ประโยชน์ของการประมูลกับ Freelancer

กำหนดงบประมาณและกรอบเวลาของคุณ

รับเงินจากการงานของคุณ

อธิบายข้อเสนอของคุณในภาพรวม

ลงทะเบียนและเสนอราคาฟรี

หมอบหมายให้:

@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 ใน 1 วัน

5.0

(38 รีวิว)

5.9

9 ฟรีแลนซ์กำลังเสนอราคาโดยเฉลี่ย $184 USD สำหรับงานนี้

@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 provide you our comments & suggestions. ARITY INFOWAY is leading growing company in outsourcing business. We are having 15+ members with expertise in various technology. Web Designing :- HTML5/PSD to HTML/CSS3/JS/Angular JS/Node JS/jQuery/Responsive Web Designing/UI Development/Frontend Development/Logo Designing/Theme Integration/AJAX/Web Services PHP:- MySQL/Core PHP/Magento/Joomla/Wordpress/CMS/Blogs/Codeigniter /Smarty/Moodle/Symfony/Yii/Drupal/eCommerce/OSCommerce/Shopping Cart .NET:- ASP.NET/VB.NET/C#/MVC/ Umbraco/Entity Framework/BioSecure Software/SQL Server/HSQL DB/Kendo UI/Telerik Control/Azure Storage/CDN Storage/WCF/WPF/Web API/HRM Integration/Desktop Applications Mobile Applications:- Android/iOS/Windows Payment gateway Development & integration:- PayPal/Avangate/Skrill/CCAvenue/WorldPay/Stripe Web Hosting:- (Linux/Windows) Hosting/Advance DNS Solution/Server Installation & setup/Mail Server/Router Configuration/Switching & VLAN/VPN/Cloud Server/Critical Data Recovery/Remote Server Support/Server Security/Web Security/Computer Help We never Place any GENERIC BID so we frequently contact you to meet you expectations. We love to spread SMILES :-)

$168 USD ใน 5 วัน

4.6

(20 รีวิว)

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 ใน 2 วัน

5.0

(7 รีวิว)

3.3

@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 have done more than 1000 web and mobile projects, which are live and fully functional. Please initiate the chat for further discussion to move forward. I look forward to working with you. Thanks.

$166 USD ใน 5 วัน