Reports Generator is very slow or Failed to fetch

Fadia year 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-tracea year ago

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

Anton Tananaeva year ago

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

Fadia year ago

I will try upgrade server

Thanks a lot for great fast response.