Page 1 of 1
Updating cache, how long can it take ?

Posted:
Mon Aug 02, 2010 4:45 pm
by pmania
Hello all, I am importing everyday some hands. I tried some full housekeeping but it hung sometimes. Now I only did an updating cache and it is still running for more then 3 1/2 hours already, I only imported 150k hands more into my database. I think I must have maybe 2.5-3mil hands, I have a intel Q9550 quad core procc with 4 gig ram and a seagate 7200 16mb cache 1.5 gig hd which is almost full.
BTW I choose for updating cache, beause it sounded faster then rebuilding cache. And where does the housekeeping information url link to, since I can't click on it now ?
Re: Updating cache, how long can it take ?

Posted:
Mon Aug 02, 2010 5:08 pm
by pmania
It finally completed in a little more then 4 hours, I can read the Housekeeping Information now i is internal in PT3.
Re: Updating cache, how long can it take ?

Posted:
Mon Aug 02, 2010 6:42 pm
by kraada
Adding new custom stats or custom columns causes the cache to be rebuilt entirely and that can cause it to take quite a bit longer. Otherwise, Update is only necessary if you manually import - auto importing should update the cache automatically when you stop the import process.
Re: Updating cache, how long can it take ?

Posted:
Tue Aug 03, 2010 12:04 pm
by popowich
I made my PT faster by dropping all of the observed hands I collected on FTP a few years ago.
Data on people from that long isn't terribly useful anyway (in my opinion)
Do you have a large number of observed hands that you can purge from your database?
Re: Updating cache, how long can it take ?

Posted:
Tue Aug 03, 2010 12:19 pm
by kraada
Purging from large databases can take quite a while; if you have a database that you're purging a significant fraction of you will likely get things done faster by exporting and reimporting into a new database.