...
Code Block | ||
---|---|---|
| ||
join_buffer_size = 32M read_rdrnd_buffer_size = 32M innodb_buffer_pool_size = 1536M innodb_file_per_table = 1 innodb_file_format = barracuda |
...
Originally, "out of the box", the cached model took a little over 2 minutes to build. With the new settings in place - and no other changes - it takes just 1 minute 16 25 seconds.
Conclusion
Despite the bad press, it is evident that you can make a LOT of difference to the performance of SDB by taking time to look at optimisations that can be made to the SQL engine. That's the trade-off of using a general purpose SQL core instead of an engine that already knows what data structures and queries it is trying to optimise for. But there is a lot of scope for improving performance simply by tuning the core, without affecting the application or the SPARQL queries that it is using.
...