Page 1 of 2
Simplify Database maintenance

Posted:
Wed Jul 09, 2014 8:40 pm
by PokerBot
Can you add a simply, one-click solution to have optimal performance, across the board for poker tracker. I have no idea what feature i should and when
I have an ssd so, as far am im aware i don't need to cluster; but still by have to click rebuild cache ; then do both options and during that process it does vacuum and analyse. Then i click on house keeping and then re index which again does vacuum and analyses, but then there are still the options of vacuum and analyses; do i have to do that again as its own separate process? And then i have to click on tune poker tracker. Would be far easier and quicker for an option to do it in one go for 100% optimal performance so less button clicking, i don't have to wait by my computer to select each individual option and sub-option i can just leave it to do its thing for an hour or whatever and presumably SQL only vacuum and analyses at the end of all other processes, not after each one? Thanks
Re: Simplify Database maintenance

Posted:
Thu Jul 10, 2014 7:32 am
by kraada
You don't need to do these maintenance options regularly. As long as you have run Database Tuning once you should be good. Vacuum/Analyze is the only thing you might want to run regularly, but the default settings have autovacuum turned on and thus it shouldn't be necessary.
Re: Simplify Database maintenance

Posted:
Thu Jul 10, 2014 12:54 pm
by zapato41
Estimado, ayer actualicé PT3 a PT4, me cargó la base de datos del PT3 pero no aparece cuando utilizo el nuevo, aparecen todos los jugadores como si fuera la primera vez.
¿ Qué debo hacer ?
Re: Simplify Database maintenance

Posted:
Thu Jul 10, 2014 1:12 pm
by kraada
Do you see your data in the View Stats area of PT4?
Re: Simplify Database maintenance

Posted:
Thu Jul 10, 2014 4:17 pm
by zapato41
kraada wrote:Do you see your data in the View Stats area of PT4?
No, solo veo lo que voy jugando, en el HUD tampoco se ven las manos que ya tenía en el pt3 de los jugadores
Re: Simplify Database maintenance

Posted:
Thu Jul 10, 2014 5:29 pm
by kraada
Then go into Tools -> Setup Assistant -> Convert PT3 database and run the conversion again. Does it show that the hands are duplicates as it imports?
Re: Simplify Database maintenance

Posted:
Thu Jul 10, 2014 5:36 pm
by zapato41
kraada wrote:Then go into Tools -> Setup Assistant -> Convert PT3 database and run the conversion again. Does it show that the hands are duplicates as it imports?
Lo estoy haciendo nuevamente, extrayendo 649200 manos. Te aviso cuando termine. Gracias
Re: Simplify Database maintenance

Posted:
Thu Jul 10, 2014 5:53 pm
by zapato41
zapato41 wrote:kraada wrote:Then go into Tools -> Setup Assistant -> Convert PT3 database and run the conversion again. Does it show that the hands are duplicates as it imports?
Lo estoy haciendo nuevamente, extrayendo 649200 manos. Te aviso cuando termine. Gracias
Extrajo todas las manos de cash, las de torneos y stoped en " extracted 164 of 165 summaries from pt3 ", no finalizacion.
Re: Simplify Database maintenance

Posted:
Fri Jul 11, 2014 3:19 am
by WhiteRider
I'm doing it again, drawing 649,200 hands. You notice when finished. Thank you
Extracted all cash held by the tournament and stoped in "Extracted from 164 of 165 summaries pt3" no completion.
That may mean that it was starting to do the import but the display hadn't caught up. But if it didn't continue and you ended it then since it got stuck on the last file you will probably be able to import the exported files manually. If you had logging enabled we'll be able to see where the exported files were written - attach the PokerTracker4.log file from C:\Users\yourname\AppData\Local\PokerTracker 4\ (which you can access from the PT4 File menu) to a
Support Ticket if you have it. That may also show us why it got stuck.
Tutorial: Reporting a problem
Re: Simplify Database maintenance

Posted:
Fri Jul 11, 2014 7:10 am
by zapato41
WhiteRider wrote:I'm doing it again, drawing 649,200 hands. You notice when finished. Thank you
Extracted all cash held by the tournament and stoped in "Extracted from 164 of 165 summaries pt3" no completion.
That may mean that it was starting to do the import but the display hadn't caught up. But if it didn't continue and you ended it then since it got stuck on the last file you will probably be able to import the exported files manually. If you had logging enabled we'll be able to see where the exported files were written - attach the PokerTracker4.log file from C:\Users\yourname\AppData\Local\PokerTracker 4\ (which you can access from the PT4 File menu) to a
Support Ticket if you have it. That may also show us why it got stuck.
Tutorial: Reporting a problem
En PokertrakerWeb4:
[0709/230643:ERROR:ipc_channel_win.cc(404)] pipe error: 232