PokerTracker Performance and SQL

Terry · #1 12-24-2005, 12:39 AM

For me, moving to PostgreSQL made a noticable difference but not a dramatic one.

Going from from 512MB to 1GB of RAM had a bigger effect.

Jonathan · #2 12-24-2005, 10:00 AM

Thanks,

I'm installing PostGresql this evening. Will upgrade
my memory to 1 Gb ASAP

beaster · #3 12-24-2005, 12:46 PM

I'm running the PostgreSQL database off of my linux machine and I can tell you that as I acquire more hands it takes longer and longer to open. Response time suffers when switching tabs as well. One of these days I think I might convert back* to access to see if PostgreSQL really is better.

*NOTE: Converting back to an Access DB requires exporting all hands and then re-importing them.

I posted about these response issues on the PT board but wasn't met with many answers. I suppose running the DB remotely (on my linux fileserver) could explain the slow response, but I'm not sure.

Jonathan · #4 12-25-2005, 07:59 AM

Interesting....

Last night I started the conversion process. I have
5 databases, and last night I converted the first, and
smallest..MyFirstPokertrackerDatabase. Even though
this particular databse is small, it took about 2 and half
hours to convert. I'm going to go through one a night
until its complete.

Mabey, I'll try getting a new machine and see if that helps.

Jonathan