Write MySQL Queries for time based reporting and table indexing design
Budget $30-250 USD
This is a simple but specific task for someone who's very knowledgeable about MySQL time based queries and table design.
The table already exists which stores metrics with a time stamp and some other fields. I already have queries running but need help with optimization of queries and creation of summary/aggregate tables.
The following 3 things are required:
1. Optimize the table including indexing and/or create new summary/aggregate tables (I think hourly time period would work) with query to automatically update summary/aggregate table.
2. Build Query to retrieve time series data (values=count/avg/min/max) from the table in minute, hourly and daily intervals ( with timezone).
3. Build Query to retrieve categories from the table in minute, hourly and daily intervals ( with timezone) - with or without pivot.
The challenge is that the table can have 1 million entries and the query should be able to produce the result as quick as it can. We can create summary/aggregate tables as well - which is also part of this project - if the query itself cannot be made faster.
25 freelancers are bidding on average $147 for this job
Hello there, it seems that you require to pre calculate the data for faster searching which is good but to be honest 1 million is not huge. Pls share me more details so we can discuss. I’ve been working with a hundred More
I have more then 15 year’ experienced in full stack .NET developer in ASP.NET Core / MVC / WinForm, C#, Razor, Jquery, HTML5, Telerik, DevExpress, SQL Server, MySQL, PostgreSQL. As i am expert, I can build it accord More
I have designed and provided solution for similar problem in past. You will definitely need a aggregator table to store results day, week and month-wise. I can help you with this. Do note that quote is not actual. Wh More
Dear my client, This is my portfolio website "for you". [login to view URL] I am a database management engineer who has top skills in database design. I have worked with various types of databases li More
SQL , Mysql Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this p More
I am profasional database designer and SQL query expert. I checked your mentioned details and confident one that I can do perfectly
Dear ! I'm ready for your Job this is owner able for me I'm work for you and complete it in professional way. Looking forward with you. Regards: Theata Solution
*** EXPERT SQL DEVELOPER *** I may provide you all queries and optimize your database according to your requirements. My expertise includes the following - MySQL - MS SQL - Oracle - .NET - ASP. NET - C#.NET - WPF - WEB More
Passion + Creativity + Experience = Success Hi,there,How are you? I am Arsen and thank you for posting a job that fits my skill set. I'm really interested in your project that requires a lot of experience and good prob More
Hello, I hope this finds you well. I have just seen your project requiring; SQL MySQL Database Programming Relational Databases I believe that my 10-year experience in this field is what you need right away. Avoid the More
7+ years experience in Reactjs / Redux / Angular / flutter / Nodejs / PHP / Django / Backned - Frontend development! All of our programming skills: *Front-end: - HTML, HTML5, JSON. - TypeScript, JAVASCRIPT (Ajax, , More
Hello , My Name Is Pedro Faria, I Have a one idea for work this , in my last work i create a query automate for users in excel and have a created variables filters and Optimized's relatory, but need a discuss.
Hello, I'm a MySQL expert, No problem to finish your job. Especially, I have strong skills in optimization of queries and creation of summary/aggregate tables I have a degree in computer science and 7 years of experie More
Hi We have a team of developers who are proficient in MySql, Oracle, and MS SQL. They work on enterprise applications like CRM, Supply Chain Management, ERP, Finance, and Insurance Domain. I assure you of timely deliv More
Hi, I sincerely hope you are doing well and safe from ✔️covid-19✔️. I like Data Modeling, DML(Data modeling language) and DDL (Data definition language) Hi, I have checked your description carefully and very interestin More
