Change database in Poker Office 2

eFe · #1 06-01-2006, 10:22 AM

I've heard people say that you should change the database format to MySQL. Why? And how do I do this?

Thanks

ihaveAdream · #2 06-01-2006, 03:37 PM

The reason to do this is that Poker Office is running a lot faster after this change, especially when you have a big database. Here's a good guide (it's not complicated at all); http://www.pokeroffice.com/forum/pos...=13&page=1

If you run into any difficulties I'll try to be of assistance.

eFe · #3 06-02-2006, 07:10 AM

Well that went smooth. Wasn't complicated at all.

ihaveAdream · #4 06-04-2006, 04:29 PM

Have you noticed it runs faster?

theRabbit · #5 06-04-2006, 09:36 PM

FYI- mySql is an open source industrial grade database. It is used by major companies and organizaions in some very large applications (terabytes). The fact that we can get it up and running with Poker Office so easily is a tribute to mySql's designer and all the programmers who worked on it for free. It is scalable so a user can get it to do more and run faster by increasing resources. I haven't worked much with it much but have worked with some of it's commercial counterparts like Oracle, Microsoft, and Sybase. Since mySql is open source, the database is free which makes it an attractive choice for many especially for web applications. In theory. if things get too slow you should be able to "tune" the database to increase performance.

eFe · #6 06-05-2006, 06:53 AM

[ QUOTE ]
Have you noticed it runs faster?

[/ QUOTE ]

I don't exactly have a huge database but yeah it seems to run faster. Especially when I'm running the live tracker.

ihaveAdream · #7 06-07-2006, 07:50 AM

[ QUOTE ]
[ QUOTE ]
Have you noticed it runs faster?

[/ QUOTE ]

I don't exactly have a huge database but yeah it seems to run faster. Especially when I'm running the live tracker.

[/ QUOTE ]

The difference is bigger the more hands you have but it's noticable even with a tiny database.

Johan L · #8 07-14-2006, 10:39 AM

How big databases do you guys have?
I make bakups of 50K hands chunks because i feel that performance is going down.
I use MySQL.
It would be nice to just keep the same database forever...

tomtemor · #9 07-15-2006, 03:47 AM

My last computer went crazy and I lost everything on it so I've only got like 30k hands in my database. I had about 70k in the old one and that worked fine as well.

Johan L · #10 07-15-2006, 10:21 AM

How many tables do you play? How many stats do you show in the overlay?