I have a Java app that needs to write single inserts into the db in an
extremely fast manner (it is receiving data in real time, and buffering it,
then doing single inserts to feed the data into the db as fast as it will
insert it). I am doing this using JDBC and this resides on the same physical
box as MonetDB 5 latest version.
Short of increasing/changing my hardware or changing my code around to bulk
write inserts (which I assume would help?) is there anything I can do to
improve the speed at which MonetDB can insert records into the db?
For this one particular table it is about 160 columns. Maybe only about 25% of
the columns are written to in any particular insert. This is literraly the
type of thing where the requests are coming in so fast that it needs the db to
keep up.
I'm sure there is room for improvement in terms of the hardware and even the
way we are writing the single inserts (i.e. maybe writing like 10 at a time or
something). But short of that, is there any configuration type of options or
optimization settings within MonetDB that could help increase the speed over
what I am getting now?
Thanks!
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
