speed

[kraada]

You'll want to run Vacuum Full in Database Management -> Housekeeping, then do a Full Cache Rebuild. Closing PT4 while the cache was updating is going to leave you in an invalid cache state and the cache is definitely going to need to be rebuilt.

[irlgtoonight]

thats gonna take days, and im just unsure, if i did create a new database can i not do all of that? i actually started doing a vacume and it had unknown amount of time, i assume i dont know but i assume it will take days same with the cache rebuilt its just i dont know whats going on, i got a computer technician coming to see me tomorow, im thinking ill just wipe the computer clean though and start fresh, seriously i started at nl2 and played 40k hands its no big deal

[kraada]

You can create a new database and reimport 40k hands much faster, yes. Just create it in Database -> Database Management, set it as Active and Default and you can delete the old database quickly and easily.

[irlgtoonight]

done, thanks. didnt know that would be instantaneous, otherwise i would of done it ages ago. now what do i need to do? ive uploaded 40k hands, and then imported about 1 mil observed hands, my database size is 7094MB and already its gone down from importing at 200 h/s to 85 h/s. well is there anything i need to do?

[WhiteRider]

Imports will slow down a little as the database gets larger, but as kraada said datamined hands will often import slower than genuine histories due to the ordering. We will not change PT4 to accomodate issues with mined hands as these are not allowed by most sites.

[potamito]

Got postgresql v9.3 and i just created a new database and reimported all the hands on the processed PT4 folder and the import speed is like 25 hands p/h at the most.

[Flag_Hippo]

We're aware that import speeds drop over large imports and until we can address this we recommend splitting your larger imports into batches.