Hi, I am evaluating SQLite for the design of the surveillance camera/DVR product based on Linux, which stores its captured analog/IP camera streams to the NAS storage device(s). To facilitate faster search/scanning of those media files containing many days of videos spread over multiple files, we plan to keep the metadata of those videos in some file format/database stored on NAS itself, so that search/analysis mechanism just go through this database to locate exact file with some search criteria like time/data/camera/alarms/events etc.
While reading the SQLite documentation I came to following FAQ, where it lists that SQLite as application file format, may not scale well to the NFS/Neworked attached drives due to the locking problems. http://www.sqlite.org/faq.html Refer 5th question. (5) Can multiple applications or multiple instances of the same application access a single database file at the same time? Is there any other way to work around this problem and use SQLite as application file format in the above scenario. See that Linux will run on the ARM9 having video processing done on specialized DSP. -- --Trilok Soni ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
