Re: [Tracker] A potiential performance issue

[Philip Van Hoof <spam pvanhoof be>]

On Fri, 2010-06-18 at 10:54 +0800, Zheng, Huan wrote:
> Hi, 
>
> I tried to insert tag for about 4000 photos, and after calling INSERT
> for 4000 times, tracker-store occupies 100% CPU, then any other
> request can not be handled.

Use BatchSparqlUpdate and don't make huge INSERT calls, split them up.

> For DELETE, the same happened.
>
> Is tracker not very good at modification?
>
> Thanks!
>
>  
>
> BTW: Iâm using libqtrackerâs rawSparql API series, have no idea about
> how to batch insert since I canât find much doc at 

SopranoLive::BackEnds::Tracker::BatchMode which you can pass to
executeQuery function and to RDFService::createTransaction

> http://live.gnome.org/Tracker/Documentation/InsertingData and
> http://live.gnome.org/Tracker/Documentation/ClientDevelopment 


-- 


Philip Van Hoof
freelance software developer
Codeminded BVBA - http://codeminded.be