database question - PokerTracker

Two Plus Two Forums Archived Forums Sponsored Support Forums PokerTracker

database question

...

05-25-2009 , 03:04 PM

roger1111

adept

Join Date: Dec 2006 Posts: 981

Nice simple question. Does a database have an infinite size? If it does why would you have more than one?

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

05-25-2009 , 03:27 PM

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

Database size isn't restricted, although if it gets bigger than your system can handle then performance will suffer. When this is depends on your system - particuarly the speed and size of your hard disk.

Multiple databases are only really needed if you do a lot of datamining and wish to only use the last few months' work of hands, for instance.

More/smaller databases = quicker searches, etc.; but you can only have one database open at once so if you split your hands across several then you won't get an overall analysis.
(The HUD can use stats from multiple databases.)

05-25-2009 , 04:29 PM

roger1111

adept

Join Date: Dec 2006 Posts: 981

Don't really understand these things but my system is now 4 years old and is

AMD Atlon 64 3400+ processor

twin 160GB SATA HDD

1GB DDR RAM (PC3200) 400MHz (2x512MB)

PC is not really used for much apart from poker and general surfing. Do you think this is suitable for a database containing at least 500,000 hands. As I said I don't really understand the technical side of computers.

05-25-2009 , 06:02 PM

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

That should work OK.
Make sure you make as much free space on your hard disk as you can, and defragment it regularly (with the postgres service stopped and all applications closed down).
Also use the housekeeping functions in PT3.

05-25-2009 , 07:54 PM

roger1111

adept

Join Date: Dec 2006 Posts: 981

Quote:

Originally Posted by WhiteRider

Not sure what you mean by "with the postgres service stopped". How do I stop it. I usually defrag with just the desktop up and nothing running.

05-26-2009 , 03:48 AM

WhiteRider

Pooh-Bah

Join Date: May 2008 Posts: 5,337

Sorry..
Start > Programs > Postgres > Stop Service

If the postgres service is still running the database files themselves may not fully defrag.
Running housekeeping again after the defrag will give you the best performance.

05-26-2009 , 07:04 AM

roger1111

adept

Join Date: Dec 2006 Posts: 981

ok thanks

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

...