OK so for various reasons my uncle runs a self written "2GB Excel Macro Monster" as company software.
(The main reason is that the unix based custom ERP, which was awesome for 20 years, disintegrated into thin air because it was still the original hard drive.... yeah backup your stuff accessible, 20 year old rotten tapes don't help you nowadays....)
Honestly what he does is sheer amazing and I never though you would be able to archive this kind of complexity with just Excel, VBA and a few Word Templates for printing.
(Even some certified MS Office experts bow before him)
Now he starts to create UIs for employees and has one major concern: speed.
He already managed to get most tasks (and those are mostly the "idiot prove, mega safety check" type of functions because Office is a bitch) under 8 sec. (which is faster than any ERP I have encountered so far) but he still complaints that they need to be under 3 sec. for a feasible workflow.
So his next step is to build a "MS Office Mega Server" but he has no clue about hardware.
He asked me for advice so I thought lets try beefier hardware which worked to some extend but still doesn't make a noticeable improvement because it isn't properly utilized.
We also tried a RAM disk and a shitload of office settings but we are unable to find the bottleneck.
It seems MS Office is really picky about hardware and you need compatible hardware to get any gains.
(This includes graphic cards and printer interfaces too)
So if anybody has experience with this topic please share it with me.
P.S. I don't have the current system specs at hand right now. I will post those when they are available.