Reports Generator is very slow or Failed to fetch

Fadi8 months ago

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 ?

Track-trace8 months ago

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

Anton Tananaev8 months ago

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

Fadi8 months ago

I will try upgrade server

Thanks a lot for great fast response.