Hi! Thank you for the answer.
> > I think the major performance options for virtuoso are > > NumberOfBuffers, MaxDirtyBuffers, MaxCheckpointRemap. Is that correct? > > Yes these are certainly important. > >.>........ > Hi, > > Two questions: > > a) what's your checkpointinterval setting? Might be advisable to disable > that until after it's done. CheckpointInterval = 60 this means every hour - right? > > b) what function(s) are you using to do the import? If you're not using it, > DB.DBA.TTLP_MT() is multi-threaded - more docs at > http://docs.openlinksw.com/virtuoso/rdfapiandsql.html . yes. i am using DB.DBA.TTLP_MT(). Also tryed ttlp but it think it was slower. I started iostat to see the disk io: iostat -m Linux 2.6.22-14-generic (lin2) 12/04/2007 avg-cpu: %user %nice %system %iowait %steal %idle 1.93 0.00 0.74 40.16 0.00 57.17 Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn sda 130.99 0.45 0.96 2925 6235 The numbers for sda are relativ constant. I dont know if this are good or normal numbers? Peter > > HTH, > > ~Tim > -- > Tim Haynes > Product Development Consultant > OpenLink Software > <http://www.openlinksw.com/> >
