On 28/09/11 15:39, Damian Steer wrote:
On 28 Sep 2011, at 15:09, Shri :) wrote:
Hi Everyone,
I am currently doing my master thesis wherein I have to work with Jena SDB
using mySQL as a backend store.
You have to work with it?
I have around 25 million triples to load
which has taken more than 5 days to load in windows platform,
I admire your persistence! How are you loading it? What type of machine is this
running on?
Sounds like it's seriously memory starved to me. [1] suggests increasing
innodb_buffer_pool_size,
which determines the db memory buffer. The default is very small.
It's also faster to load the data and then build the indexes.
Damian
[1]<http://openjena.org/wiki/SDB/NotesMySQL>
Are you using the sdb bulk loader or loading via your own code?
What format is the data in?
(this Q is also on answers.semanticweb.com)
Andy
