PokerTracker

Hi, somewhere I read that it is good to cluster/vacuum/analyse the database
on regular bases like every 100K hands.
So, if I create a new database and I want to import like 1Mio Hands,
should I do this every 100K hands and then import another 100K and so on (which would take a lot of time, since clustering is quite time consuming)
or do I have the same effect when I import them all at once and then do all the clustering etc.?

Import them all at once then do a big cluster. :)

Clustering in increments of 100K hands during a 1M import will just be a waste of time...

Best regards,

Derek

Ok thanks, another question:
What would be the most effective way after I imported that Mio hands? First Vacuum then cluster then analyze?
Or does it not matter what I do first and last?

Greetings

I'm pretty sure the Cluster does a Vacuum first, so doing a separate Vacuum isn't necessary. Analyze after the Cluster.