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

Reply via email to