lol. Wish I had and I recreated the wheel. I thought I read all of that thread! Brady is awesome!
I read up on a lot. In short, the sample files, eg, my.ini-small/medium/large do not refer to business size but mysql usage, so those were useful. The threads Brady showed in the other post would likely have fixed the problem but I’ll share what I did because staff are really happy today with what I did. Initially, I got the superbill to load in 2.5 minutes and this morning it loaded in 20 seconds, then office staff said it loaded for them in 2 sec.
innodb_buffer_pool_size = 3000M ( or 3G)
Some places say you should set this to 50-80% of your total RAM but if you try to go >=4G then you get an error in mysql_error.log telling you you cannot go over 4G with 32-bit applications. I found I cannot go over 3G without getting that error.
innodb_log_file_size = 1G
I read it was suggested this value be 25% of the buffer pool size, this is 33%
A stack exchange post suggested setting buffer size to 128M from 8M, so:
innodb_log_buffer_size = 128M
And lastly, from the my.ini-large file and some overstack posts:
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
There were 1-2 other changes I made but I do not think they led to meaningful changes. I will update if anything whacky happens as the day progresses.
Thank you Stephen for your support!