Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Mon Jul 23, 2012 6:29 pm

I have my 10 M database, imagine that i want to add 200 K more. My % of cache status is not going to decrease more than 10 %, so i dont need to make a rebuild, just an update [The rebuild is mega slow, it would be better to create a new DB]

The question here is you are telling me that with PT4 im going to spend less time importing these 200 K hands than in PT3 importing the 200 K hands and later making the update cache progress.

Can you tell me, more or less, how much would be the reduction of time in %? Its importante for me.

I have tried too to import hands while i play. I mean, i put the hand history in the auto import folder and it starts to import these hands but it doesnt work the HUD. Do you know how i would be able to do it? Maybe the DB is so huge for this or its a problem for the cache.

If you are so kind, i would like a nice explication about these two points. Im importing a lot of hands every day (multilobby and multistake) and i lose a lot of time with this stuff, if you can give me some tip, you are welcome.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby WhiteRider » Tue Jul 24, 2012 4:03 am

The speed difference won't be huge, but PT4 should be a little faster overall.

parraka wrote:I have tried too to import hands while i play. I mean, i put the hand history in the auto import folder and it starts to import these hands but it doesnt work the HUD. Do you know how i would be able to do it? Maybe the DB is so huge for this or its a problem for the cache.

Do you mean that you're actually playing, or just moving HH files into the folder?
The Hud should work while you play, but there won't be a Hud if you're just copying files in as there won't be a table to display on.

If you're having problems with the Hud while playing please check the FAQ: PT3 HUD.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Tue Jul 24, 2012 5:04 am

I put a Hand History with hands and it start to import them (auto import) . I sit in a table and the hud doesnt display. If i stop auto import and i remove the hands from the Auto Import Folder, if i open a table and i start auto import again, i have the hud in the first hand.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby kraada » Tue Jul 24, 2012 8:32 am

You don't want to use Auto Import to get hands from large text files - in PT3 use Manual Import and in PT4 use Get Hands From Disk - these are designed to take hand history files and parse them quickly to get the information into the database. Auto Import (or Get Hands While Playing) is meant to be used while playing - when hands come in at a relatively slow pace (from a computer perspective).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Tue Jul 24, 2012 9:24 am

I know, but i can save time if im importing hands while i play, no?
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby kraada » Tue Jul 24, 2012 12:33 pm

The auto importer can't handle that many files. You could put 20 or 30 files there or something per session but I don't know how much time that's really going to save you in the long run.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests