I have a database with ~10m hands and ran a profiled range research which spit out ~3500 players. Currently, I am on hour 8 and still saving results into database. The progress bar has froze a few times but keeps chugging along.

This isn’t a complaint, I know it’s a lot of data. I just don’t want to end up watching a progress bar for a few days when in reality the job is not being done. More so I’m terrified of opening another application right now and losing all progress.

Any typical timelines for this sort of job? Should I make the range research parameters tighter to keep the data smaller?

Thanks guys, really enjoy your product!

This is a known problem with the current database system, sometimes range research reports on a large db won't save at the end. This will be fixed in Hand2Note 4 when we switch to a new database system. As of now, if you're having this problem, I'd recommend using smaller db or stopping the process halfway.

Using smaller DB how? I’m not sure how to split a database but I’m sure you have a tutorial.

When will 4 be out? Can I possibly have a trial key for beta?

Thank you for quick response and great work!

1. You can create new DB For Range research and import there less hands. Or you can split your report to the simple parts.

2. The exact date of H2N4 release I can't tell you. But we are working on it.

3. You have to leave request for trial key https://beta.hand2note.com/. The keys are shared randomly.

1) not really clear here. Currently I have a DB w 10m hands that took quite a while to import. Are you telling me to do it all over again but in smaller slices?

How small? I don’t want to run another report that is going to a) tie up my machine for 25 hours b) not end up going through.

Not trying to be difficult but I bought the software for this specific purpose and now it’s turning into a headache.

Can you please give me a step by step plan to get all 10m hands analyzed? If it is not possible until release of h2n4 then I will not renew until it’s out. Quite frankly I don’t see point of range research if the software can’t handle 10m hands.

Some tips to make RangeResearch work with larger databases:

1) Try to use Base Stats filters or Expression filters to lower the amount of found players, ideally try to test it with lets say 1000-2000 players and try to increase it until it will not freeze for you. You can do that by being more specific or just by increaasing required hands filter.


2) Another method is to cut the main popup that you are using into smaller popups. That way it will require lot less resources to run and you should avoid freezes.

Lets say you want to study topic: Caller In Position

a) So you open popup editor.
b) Right click tab"Caller IP" select "Copy tab"
c) In range research report select Create popup
https://www.dropbox.com/s/8h02ygv906...02837.png?dl=0
d) Paste the tab which you have copied into that newly created popup
e) Run range research report


That way it should not lag even when you will use large amount of filtered players.

Current Hand2Note version does work well with large databases. Hopefully it will not be the case with Hand2Note 4. It will be using custom made Database probably with better performance.


Also it should be more optimized for the latest processors available on the market. Currently Hand2Note does not work well with the multi threaded processors like AMD.

You can get a refund within fourteen (14) days of purchase or you can freeze your subscription if recommendations above wont work for you. Just send a request to support@hand2note.com

Not seeing those images you posted.

Now it is staring to make sense.

Basically I can analyze a large database of hands but I should do it on a narrow scale, such as look only for SRP position vs position for example?

Sorry for confusion, I've never been the brightest bulb and I am dimming with age.

To be clear, once I initially import all my hands (~10m) from other database, I don't need to re-import those hands but I do (currently) need to be relatively precise when i query that database via RangeResearch?

Please post those images again as I want to make sure I do it right.

FWIW I was running an entire complete report on 10m hands with a short cutoff (50 hands) and using a HUD similar to the DeathStar that you guys sell. Intensive research so I guess I'm not surprised Im having issues.

I don't want to freeze as I was loving the software when I was using a 3m sample. Now up to 10m and I'm just frustrated but it appears there are solutions so I will adjust.

Yes , you are correct. You have to narrow your research a bit. Either by decreasing amount of players, or splitting your main popup into smaller one. Or doing both if it will not work or work too slow.


I have upload these pics into dropbox. And added links.

If you are using separate databases or configs of Hand2Note for playing or range research or having multiple databases with different settings.
To make it easier for yourself what you could do is to make a copy of Hand2Note root installation folder and to create as many copies of Hand2Note as you need. Then launch a Hand2Note icon that you need. That way you do not need to change settings,databases, HUDS and etc.

So basically I will have a desktop icon of H2N labelled "Tags vs Cbet OOP" that will save all of my range research data for that situation and have it on demand as opposed to having to re-build from scratch?

This is becoming less of an issue with every one of your suggestions, so I appreciate the time. I requested a beta trial key from your link. On a scale of 1-10 how much easier is all of this stuff going to be in H2N 4?

EDIT:
How long should a research query take before I decide, well it's too big and not working?

Right now I am going to look for one specific situation with a cap of 2k players found. Are we talking 6 hours here before I give up....12?

Range research can be found here: https://www.dropbox.com/s/hubpn1al2e...ports.jpg?dl=0 so you do not have to rebuild them

I mean if you are using Hand2Note without copies, and you decide to use 1 HUD and 1 database for playing and another HUD and different database for Range research. Everytime you want to switch from playing to range researh you will have to delete previous config folder, insert config folder of desired action play or RR. In case if you forget that you can mess everything up. So that way you make it more simple.

http://hand2note.com/Help/pages/Rang...earch-and-play


Do not have any information yet.

Current Hand2Note version does work well with large databases. Hopefully it will not be the case with Hand2Note 4. It will be using custom made Database probably with better performance.

Also it should be more optimized for the latest processors available on the market. Currently Hand2Note does not work well with the multi threaded processors like AMD.

Directions for copying root folder of H2N?

found, ty.

For specificity I *only* use H2N for range research. I use a different app when I am playing.

I am guessing I will figure this out. Simplest answer seems to be to keep players found under 2k and only query for specific situation I am studying. If I still have issues I will build databases with no more than 5m hands and paste data together myself. In that instance it seems I need to figure out the multiple instances of H2N.

You have made an annoying situation bearable so I appreciate it immensely.

Hard to say, it could be different for everyone.

Doing Range research should not take long. Building stats takes long time.

Today 1 user reported That he experienced freezes after 6000 players.

On mine machine with mine HUD setup (not the one for Range research) 6000 players will be filtered with speed 1 player per second. So it would take 1 hour and 40 minutes to filter them.

According to that user RR report took 1 minute or so to save after RR found all the players. He was using complicated package as you do too.

Thank you for your help.

I had zero issues running huge reports with many different stats/sizings etc at ~3-5m hands so worst case I will just have different databases for different chunks of hands and paste the overall data together. There are silver linings to this method if I can get databases in sequential order by date so not all is a setback.

Nice customer service, it's appreciated.

You're welcome. Thank you for using Hand2Note.

Friend,

Can I (relatively) toggle between smaller databases via configuration tab?

I've been up experimenting and it seems if I keep the total DB around 5m hands I don't run into issues.

Sorry for simplistic question but the software quite frankly scares me and I'd rather ask dumb questions before doing anything.

Hello. Yes, you can easily create multiple databases and switch between them.

Hi, you can also pre-configure multiple H2N folders with different connected databases and just launch the H2N folder you want.

To create a copy, just copy the Hand2Note folder to C:\Program Files, then paste it on your desktop and, if necessary, run the program from this folder.

I have this issue right now.
My DB is like 45M hands. Importing HHs and building stats looks done finely. But range research took many hours...and it never ends.
This problem would be caused because of poor CPU/RAM? Mine is like AMD 12 threads / 32GM RAM...
H2N 4 with AMD CPU would also fix this problem?

Hello. Try to turn off AMD Simultaneous MultiThreading in the bios settings.

If that doesn't help, break up your popup into several smaller popups and build several reports on them.

Thanks It worked.

Which one worked? Turning off AMD Simultaneous MultiThreading in the bios settings or breaking up your popup into several smaller popups and build several reports on them?