Write MySQL Queries for time based reporting and table indexing design

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.

Habilidades: MySQL, SQL, Programação de Banco de Dados, Relational Databases

Acerca do Empregador:
( 3 comentários ) Apex, United States

ID do Projeto: #32713343

Concedido a:


Good Day, One of my speciality is mySQL DBA. Part of my daily work is query optimisation against the database data model. I work with data comprising of multi million row large datasets. My rule of thumb is if a qu Mais

$98 USD em 7 dias
(0 Comentários)

25 freelancers estão ofertando em média $147 nesse trabalho

(61 Comentários)

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 Mais

$250 USD in 3 dias
(44 Comentários)

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 Mais

$100 USD in 7 dias
(30 Comentários)
(5 Comentários)

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 Mais

$250 USD in 7 dias
(11 Comentários)

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 Mais

$140 USD in 7 dias
(1 Comentário)

Hi Hiring manager C#,, ETL, BI, DBA, SQL and PL/SQL Expert 15+ years experience in software development, database programming and administration, and project management. My proficiency are given in the follow Mais

$250 USD in 2 dias
(2 Comentários)

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 Mais

$200 USD in 7 dias
(24 Comentários)

I am profasional database designer and SQL query expert. I checked your mentioned details and confident one that I can do perfectly

$50 USD em 1 dia
(13 Comentários)

Hi There!! No upfront milestone and 24*7 Support With a 100% money-back guarantee. We are here to provide the best quality solution for all your requirements related to: - Websites design and development - Online Store Mais

$190 USD em 1 dia
(3 Comentários)

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

$100 USD em 1 dia
(8 Comentários)

*** 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 Mais

$100 USD in 2 dias
(6 Comentários)

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 Mais

$200 USD in 7 dias
(1 Comentário)

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 Mais

$140 USD in 7 dias
(1 Comentário)

Hi there, I have more than 5 years of experience in web design and development. I think your job is very suitable for me . Our skills: Programming Skills: AngularJS, Bootstrap, CSS3, HTML5, jQuery, JavaScript and Ajax Mais

$150 USD in 3 dias
(3 Comentários)

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, , Mais

$250 USD in 2 dias
(1 Comentário)

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.

$30 USD in 7 dias
(0 Comentários)

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 Mais

$50 USD in 3 dias
(0 Comentários)

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 Mais

$230 USD in 7 dias
(0 Comentários)

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 Mais

$140 USD in 7 dias
(0 Comentários)