View Single Post
  #2  
Old 09-21-2005, 08:46 PM
IHateCats IHateCats is offline
Member
 
Join Date: Mar 2005
Posts: 68
Default Re: Poker Ace or PlayerView?

There isn't a significant difference in database performance between the two, they are both passing virutally the same sql calls via odbc, these are pretty much standard PT queries so both are relatively well indexed. However if you are using very large db's you would be well advised to convert to postgres from Acess and preferably get them onto another machine/server as Pokertracker itself is quite cpu intensive. Disk I/O is very important for any PT database with a lot of hands with either Access or postgres, so get as fast of a drive as you can afford and defrag it frequently and also compress/compact frequently as well as index performance will be substanially better if your disk & db are not fragmented. And finally, if you can't afford to throw hardware at the problem, try to keep the database size to 100k or below.
Reply With Quote