I need help, PT3 is slow

[parraka]

I dont know what happen but my PT3 starts to works slowly when i make big database, more than 1KK hands, SH.
I never make any type of housekeeping, im importing about 100K hands every day, so, what is the best option for me? do i have to make any type of housekeeping everytime that i import hands?

Please tell what is the correct way step by step, i want a fast PT3, actually i have to wait like 5-6 hands to have the HUD loaded and it sucks.

I have read something about cache status, actually is 0%. I think always is = 0, is this possible? Do i have to watch it while im playing, with the hud loaded?
Really, i need help with this issues, i think im doing something wrong.

My computer is a Pentium i7, 8 GB RAM Kingstom, 500 GB 7200 RPM, i think is more than enough.

[WhiteRider]

The first step is to run housekeeping to optimize the database - that will make a huge difference. For a large database it will take some time so you may want to run it overnight or something, but that is how things are designed to work and if the cache is not at 100% performance will be affected.

You may find doing something like this helps too, but you definitely need to keep your database(s) cache at 100%: Tutorial: Managing Multiple Databases

[parraka]

Do you recommed me to delete my Database? I have read about how to configure it for more performance.

[kraada]

If you're doing configuration like that explained here then deleting your database won't make a difference - it just tunes the resources that PostgreSQL is allowed to use from your machine. The database itself doesn't change.