Re: [Tracker] Fw: Tracker support for Bluetooth/ipod

[Martyn Russell <martyn lanedo com>]

On Fri, 2010-05-14 at 20:39 -0700, Remo Remo wrote:


> is it possible for tracker to insert metadata in user-provided SQLite
> database. 

Hmm, you mean one YOU provide? or a separate database for user data?

If you mean the former, how would you expect that to work? If you mean
the later, we don't do that right now.

> Here, if i don't have direct access to database, then i am thinking
> that tracker should maintain metadata for each device in separate
> SQLite database provided by user to avoid table scanning & increased
> response time. This will be very useful features in our environment.

We don't do that. Joining data from multiple databases is less efficient
than keeping it all in one database/table. Also with SQLite using
multiple databases is far from elegant, we had this solution in 0.6. and
it had its fair share of issues.

Regarding table scanning, do you have any data to prove this is an issue
with Tracker (0.7+) ?

We are currently working on improving the response time by looking at
the IPC we use and also by considering a direct-access library.

-- 
Regards,
Martyn