On 12 Apr 2010, at 10:58am, Navaneeth Sen B wrote: > 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
SQLite can certainly return more than 3000 records without problems. But I'm not sure why you're asking about SQLite but talking about .jpeg files. A file is a file. It lives in a directory on a disk, not in a database. If you want to keep picture information in a database, it's just another BLOB field, not a file at all. > * Cannot simultaneously update and list the contents in the table > * Sorting can be done only by using a maximum of two fields These two are not problems, depending on how 'simultaneous' you want to be (milliseconds ?). SQLite handles multi-user locking if your CE platform and operating system does. By the way, I don't know what 'CE' means. > [snip] > > 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? Same comment as about the .jpeg files: it doesn't, and nor does any other SQL database system. No database system stores files. That's what a file system does. A database could store the bytes that made up a file, but as you point out AVCHD 'files' are not files at all, they're collections of files (directories, but more like 'bundles' if you're used to Mac OS X), so you'd need to invent a convention for explaining which bytes came from which file. I think you need to decide how you want to handle these files. Either keep the files on disk and just store the path/filename in a database field (in which case they're just short text fields and trivial to handle) or read the bytes out of the files and store them in BLOB fields (which will take a lot of programming and your database will be huge). Either way, the database is still not storing a file, it's storing text or a BLOB. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
