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>
