Re: [sqlite] How SQLite solves these issues

On 12 Apr 2010, at 11:47am, Navaneeth Sen B wrote: > Hi Simon, >> 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. > > D

Re: [sqlite] How SQLite solves these issues

On Mon, Apr 12, 2010 at 11:33 AM, Navaneeth Sen B wrote: > 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 >> yo

Re: [sqlite] How SQLite solves these issues

Hi Simon, > 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. > > Does that mean it does not support this kind of concurr

Re: [sqlite] How SQLite solves these issues

Thanks Simon, > 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 datab

Re: [sqlite] How SQLite solves these issues

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 w

Re: [sqlite] How SQLite solves these issues

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

Re: [sqlite] How SQLite solves these issues

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 wrote: > Hi

[sqlite] How SQLite solves these issues

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 s