Hi Henrik,
I have thought about this as well. One way to be sure is roughly this
recipe.
First turn off swap!
mkdir my_ram_disk#needs a directory
mount -t tmpfs -o size=50G tmpfs my_ram_disk #50G in size
cp existing virtuoso.db files etcc to my_ram_disk
make a new virtuoso.ini pointing to these files
start virtuoso
Off course the question is if it will improve performance in comparison
to giving more buffers to virtuoso and OS io cache. This you will need
to test.
Regards,
Jerven
On 07/04/2017 04:18 PM, Henrik Schmidt wrote:
Hi,
we have a database of about 850mio triples, the file virtuoso.tx is
about 50GB size on disk.
While our application will only do SELECT queries.
What is the best configuration to keep the complete set in RAM so no
disk reads apart from the initial caching is needed ?
How can we configure this complete caching on startup ? We have 128GB
RAM available for this.
Best,
Henrik
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
---
Jerven BollemanJerven.Bolleman@sib.swiss
SIB Swiss Institute of Bioinformatics Tel: +41 (0)22 379 58 85
CMU, rue Michel Servet 1 Fax: +41 (0)22 379 58 58
1211 Geneve 4,
Switzerland www.sib.swiss - www.uniprot.org
Follow us at https://twitter.com/#!/uniprot
---
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
