HEM cash graphs lagging

[sangpomm]

Not sure whats going on but if i put like example 4544 last hands, then its taking more than 15 minutes to load graph. but if select speciffic month or smth.(50k-80k hands) then its taking only couple of seconds.

[Patvs]

What sort of harddisk do you have?

Which PostgreSQL version are you using?

---


Some queries are a big load on the database, and require a lot of CPU power to crunch, for example: having an ALIAS with hundreds of players attached to them and then running reports, or replaying or exporting thousands of selected hands simultaneously from the Reports tab.

Instead of using the custom filter to select the last 4544 hands, try using a custom date filter, to select the hands from the specific date range those hands were played in.