Hi, we have 2 virtuosos and a java client with the following flow: phase#1: java app client reads triples from a rabbitMQ queue and writes them to virtA then puts the messages back to RabbitMQ (in a different queue) phase#2: java app client reads the message from rabbitmq (that was put back), reads from virtA, does some business logic then writes to virtB.
virtA and java client are on the same server, virtB is on a 2nd server and rabbitMQ on a third but all are in the same LAN. so far we noticed that writing speed of virtB increased if we separated the phases (therefore writing and reading to/from virtA doesn't happen at the same time. So we run phase#2 after messages from phase#1 are processed.) This way the speed of writing to virtB increased from 150triples/s to 1500triples/s, but the speed of writing to virtA is about 15000 triples/s. in both virtuoso's log we see "Locks are held for too long" error msg we use virtjdbc4 driver to write to virtuoso one difference is that virtB's storage is stored on a network disk. virtA NumberOfBuffers = 7000000 MaxDirtyBuffers = 3500000 virtB NumberOfBuffers = 4720000 MaxDirtyBuffers = 2500000 Does anyone have an idea why we experience such a difference or how could we speed up insert speed of virtB? Regards, Balazs Varhegyi ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ _______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
