I have a solution to creating a report of our company's unit hours of
activity (time spent serving a call) based on an accompanying call log
table, however, my queries take HOURS and HOURS to run (8+). As a
result I can't provide the report as often as the powers that be would
like it. Our table contains more than 1 million records and sensitive
data so I can't provide test data. :/
Let me explain the situation.
- Start and Stop times for each call are available
DROP TABLE IF EXISTS `tbluhadata`;
CREATE TABLE `tbluhadata` ...