Reports Generator is very slow or Failed to fetch

Fadi2 years 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-trace2 years ago

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

Anton Tananaev2 years ago

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

Fadi2 years ago

I will try upgrade server

Thanks a lot for great fast response.