Thanks Hamish, But can you give me more clarity for the sentence in the quoted text. > However, it doesn't store files, it stores data. If you need to query > (meta)data from a particular file format, you'll have to extract it > yourself. > Regards, Sen
_ On 4/12/2010 3:44 PM, Hamish Allan wrote: > Hi, > > SQLite will outperform the DB you describe in every aspect. > > However, it doesn't store files, it stores data. If you need to query > (meta)data from a particular file format, you'll have to extract it > yourself. > > Best wishes, > Hamish > > On Mon, Apr 12, 2010 at 10:58 AM, Navaneeth Sen B > <navanee...@tataelxsi.co.in> wrote: > >> Hi all, >> >> Currently I am working in a project where we are developing a CE >> product, which is using a DB which was developed by one of our teams. >> I am facing some of the below mentioned issues with the current DB: >> >> * Listing of more than 3000 .jpeg files will produce a system hang >> * Cannot simultaneously update and list the contents in the table >> * Sorting can be done only by using a maximum of two fields >> >> So right now we are thinking about moving to SQLite as it has proved its >> features in many CE devices. >> But still I would like to get more clarity in the above issues and I >> would like to know how SQLite solves the above issues. >> >> I would also like to know how SQLite stores AVCHD files in the DB. >> As you know AVCHD files have a peculiar directory structure(association >> with .cpi files), how is it handled in SQLite? >> >> Regards, >> Sen >> / >> /// >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users