Upgrading the RAM would have more benefit. Fuseki uses TDB which relies on memory mapped files so if you can provide more RAM more of your data can be kept in memory by the OS. Bear in mind that this memory is off-heap so if you do upgrade your RAM there should be no need to set the heap size larger since the additional RAM Will be utilised by the OS to cache more of your data in memory.
Another hardware upgrade that you did not mention would be to your storage. If you frequently load new data from disk then providing high-performance storage i.e. SSD/flash device Will give you significant performance gains for those operations. However, as a general performance upgrade I would strongly recommend more RAM Rob On 22/11/2017, 00:40, "John Sanders" <[email protected]> wrote: Hi, I'm running a Fuseki server on a rather small server. I'm willing to upgrade it a little bit (since it's handling a lot of requests) so I was wondering which single component I could upgrade to get the best possible return. This I suppose boils down to either more RAM or a better CPU. Currently the server is an old Pentium4 3GHz with 2gb of RAM, so if I have some money to spend on it, would I be better buying more RAM or a better CPU? In the second case (a better CPU), would Fuseki benefit more from a faster one (higher frequency) or one with more cores/threads (I assume Fuseki is a multi-threaded application)? Thank you all.
