PokerTracker

when i ran my database on an USB stick, the import speed was like 10hands/second. can you explain why this is? also clustering at the end of the postgres setup took a few minutes.

would be so great to have the database on an USB stick, so it could be easily shared between desktop and laptop..

There is so much disk access required by the database that I'm sure the USB connection just can't go fast enough.
I don't have any figures, but I'm sure someone will be able to tell you just how much slower it is..

what i was wondering is, if PT3 doesnt use transaction begin/commit commands. seems like it is writing after each hand to the database instead of buffering most possible hands before finally writing them to the disk.

the actual speed for importing hands and retrieving stats while playing is ok. the problem is you cant create/reimport a 500k hands database with ~10 hands/second as that will take 15 hours. maybe i shouldnt have tested the cheapest usb stick available with 7MB/second. but i dont have the 150 bucks to test a turbo usb stick.