On 27/08/13 08:34, Claude Warren wrote:
Does anyone have a measure of max insertion rate for TDB and/or other
storage implementations? I am trying to determine if it is feasible to use
Jena in an environment with frequent small (7-19 triples) inserts and
infrequent (7x day) reads. This is essentially a system to store some
application logging data for various reports run on daily, weekly or
monthly schedules (You know, your standard business reporting requirement
type stuff)
Claude
How frequent is frequent? Sub-second?
TDB should be able to handle several a second transactionally, more
non-transactionally. Transactions of 20 triples are going to bounded by
disk IO. A write transaction involves a disk sync to commit it and that
will limit the rate.
Non-transactionally, you can let a few updates through then call sync()
or run continuously and let the system write back to real disk (at the
risk of loss of data on a crash).
If it's a batch of 20 triples a minute then less of an issue.
Personally, I'd batch and use transactions.
Andy
