Optimizing Mysql Query Performance on large table

$30-250 USD

Teljesítve

Kiadva ekkor:

több mint 7 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve

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)

Projektazonosító: 12715346

A projektről

9 ajánlat

Távolról teljesíthető projekt

Aktiválva: 7 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 napon belül

5,0

(38 értékelés)

5,9

9 szabadúszó adott átlagosan $184 USD összegű árajánlatot erre a munkára

@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 napon belül

4,6

(20 értékelés)

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 napon belül

5,0

(7 értékelés)

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 napon belül