Reports Generator is very slow or Failed to fetch

Hello

Its very slow to generate daily summery report or any other report and if ask for report for more than 2 or 3 days period i got failed to fetch

I have 101042432 positions record in positions table

I need to get daily summery report for something about 50 cars for 12 months

Server
Xeon Quad Core E3-1230v3 3.3 GHz
8 GB DDR3-1600 ECC SDRAM
Hard Drive: 1 TB SATA HDD (7200 RPM)
1 Gbps Uplink Port Speed
CentOS 7.0 - 64 Bit

any suggestions ?

More Memory, nvme drive and faster CPU should help you a lot.

The hard drive is the main issue. You definitely need an SSD if you want it to be faster.

I will try upgrade server

Thanks a lot for great fast response.