V5.0.0 too slow on Windows

[brady.miller]

Hi @arnabnaha ,
Would be more ideal to modify it. Is there a way you could copy/paste exactly what you have in your my.ini file now. Then I’ll rebuild the xammp/openemr package with that my.ini file.
-brady

[arnabnaha (Dr. Arnab Naha)]

Hi brady,
I am emailing you the my.ini file i have. Hope it helps you!

Thanks and regards,
Arnab

[brady.miller]

Planned changes making on the xampp default my.ini for recording purposes:

1. innodb_buffer_pool_size from 16M to 256M
2. innodb_additional_mem_pool_size from 2M to 20M
3. innodb_log_file_size from 5M to 64M

An odd thing I noted but did not change is that the key_buffer is used rather than key_buffer_size (this is myisam specific, so didn’t touch this, though)

[brady.miller]

Hi,

I just released a new xampp/openemr 5.0.0 package with the registration bug fix and changes to mysql settings(see above post for exact setting changes). Please test and let me know if the speed is improved.

thanks,
-brady

[brady.miller]

Some very nice tips for speed optimization can be found on this thread:

V5.0.1(6) slow patient load times on Windows Server

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,…

[cverk]

In addition to Brady’s suggestion which are great, I think I have found the solution that makes continuing to use windows viable instead of frustrating. Others may not like to here this but it basically involves a new faster computer. A 10th generation I7 processor, 8GB of ram and a SSD hard drive and the speed issue seems to vanish.