It is very hard to say without having the actual files you are working on.
Hotlinks will obviously slow the master file down as you are linking to an external file - or in you case it sounds like 100s of external files.
I have had some issues with hotlink speeds in the past and I found that it is important to make suer all files are saved in the same version of Archicad.
Also make sure that you are not using any old version or migrated libraries.
If you are then every time Archicad needs to access that module, it opens it in the background and has to migrate all of the libraries before you can do anything with that module.
Here is a post where I was experiencing slowness as well.
https://archicad-talk.graphisoft.com/viewtopic.php?f=37&t=62731&hilit=module
I don't know if saving all the modules in the same version and making sure they all have the same library (& not migrating libraries) will help or not, or whether it is just the shear number of modules you have that is the problem.
Barry.
One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11