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.
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 Daha Fazla
Bu iş için 25 freelancer ortalamada $147 teklif veriyor
I am profasional database designer and SQL query expert. I checked your mentioned details and confident one that I can do perfectly
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 Daha Fazla
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.