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 freelancer chào giá trung bình$147 cho công việc này
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
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.