[sqlite] Speed comparison (was: [sqlite] Lock files....)

2004-09-25 Thread Hans-Juergen Taenzer
b.bum ([EMAIL PROTECTED]) wrote: > SQLite3 produces smaller data files thats true, > and is faster, in general, than did SQLite2. but this is not my experience. In my small applications (about 20 records) inserting and searching with SQLite 3.0 is slower than SQLite 2.8 (about 25%). Ther

RE: [sqlite] Lock files....

2004-09-24 Thread Fred Williams
>-Original Message- >From: Mauricio Piacentini [mailto:[EMAIL PROTECTED] >Sent: Friday, September 24, 2004 1:42 PM >To: [EMAIL PROTECTED] >Subject: Re: [sqlite] Lock files > > >Fred Williams wrote: >> I picked SQLite for its minuscule (by today's

RE: [sqlite] Lock files....

2004-09-24 Thread Fred Williams
>-Original Message- >From: b.bum [mailto:[EMAIL PROTECTED] >Sent: Friday, September 24, 2004 1:34 PM >To: [EMAIL PROTECTED] >Subject: Re: [sqlite] Lock files > > >On Sep 24, 2004, at 11:16 AM, Fred Williams wrote: >> I picked SQLite for its minuscule (b

Re: [sqlite] Lock files....

2004-09-24 Thread Mauricio Piacentini
Fred Williams wrote: I picked SQLite for its minuscule (by today's standards) footprint, simplicity, and ease of deployment. Why do I get the feeling I've bought into a product like any model in the American car market. With each passing interation the vehicle gets bigger, fatter, and less efficie

Re: [sqlite] Lock files....

2004-09-24 Thread b.bum
On Sep 24, 2004, at 11:16 AM, Fred Williams wrote: I picked SQLite for its minuscule (by today's standards) footprint, simplicity, and ease of deployment. Why do I get the feeling I've bought into a product like any model in the American car market. With each passing interation the vehicle gets

RE: [sqlite] Lock files....

2004-09-24 Thread Fred Williams
: Friday, September 24, 2004 12:34 PM >To: [EMAIL PROTECTED] >Cc: Ara.T.Howard >Subject: Re: [sqlite] Lock files > > >On Sep 24, 2004, at 10:42 AM, Eddy Macnaghten wrote: >> I am getting some tests together now. As soon as I have got it ready >> enough I will put it on my

Re: [sqlite] Lock files....

2004-09-24 Thread Ara.T.Howard
On Fri, 24 Sep 2004, Eddy Macnaghten wrote: An attraction of SQLite is that it is all client based - making almost practically zero cost administration. Although this is not an issue on implementations that have an IT department, it makes a BIG difference in supporting the penny-ally implementatio

Re: [sqlite] Lock files....

2004-09-24 Thread b.bum
On Sep 24, 2004, at 10:42 AM, Eddy Macnaghten wrote: I am getting some tests together now. As soon as I have got it ready enough I will put it on my site and inform the list... As a part of your tests, it would be helpful to have some abuse tests that involve multiple processes reading/writing ag

Re: [sqlite] Lock files....

2004-09-24 Thread Eddy Macnaghten
On Fri, 2004-09-24 at 16:50, Ara.T.Howard wrote: > On Fri, 24 Sep 2004, Eddy Macnaghten wrote: > > > There is no way I can guarantee the "nfs" to be good. Also, a mixture of > > Linux and Windows clients need to be allowed for, I do not know how SAMBA > > supports the fcntl functionality, or how

Re: [sqlite] Lock files....

2004-09-24 Thread Ara.T.Howard
On Fri, 24 Sep 2004, Matt Sergeant wrote: On 24 Sep 2004, at 17:43, Ara.T.Howard wrote: On Fri, 24 Sep 2004, Matt Sergeant wrote: On 24 Sep 2004, at 14:51, Ara.T.Howard wrote: What are people's views on this? i think it's sufficiently common to merit discussion on best practices at least. More tha

Re: [sqlite] Lock files....

2004-09-24 Thread Matt Sergeant
On 24 Sep 2004, at 17:43, Ara.T.Howard wrote: On Fri, 24 Sep 2004, Matt Sergeant wrote: On 24 Sep 2004, at 14:51, Ara.T.Howard wrote: What are people's views on this? i think it's sufficiently common to merit discussion on best practices at least. More than that, I'm thinking there might be a call

Re: [sqlite] Lock files....

2004-09-24 Thread Ara.T.Howard
On Fri, 24 Sep 2004, David Fletcher wrote: Hi all, http://opendlm.sourceforge.net might be an interesting place to start. great link. thanks! -a -- === | EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov | PHONE ::

Re: [sqlite] Lock files....

2004-09-24 Thread Ara.T.Howard
On Fri, 24 Sep 2004, Matt Sergeant wrote: On 24 Sep 2004, at 14:51, Ara.T.Howard wrote: What are people's views on this? i think it's sufficiently common to merit discussion on best practices at least. More than that, I'm thinking there might be a call for an os_nfs.c that uses this NFS clean lock

Re: [sqlite] Lock files....

2004-09-24 Thread David Fletcher
Hi all, http://opendlm.sourceforge.net might be an interesting place to start. -- David Fletcher Tuscany Design Automation, Inc. [EMAIL PROTECTED] 5875 S. Danube Circle 303.690.4309Aurora, CO 80015-3169 USA > "MS" ==

Re: [sqlite] Lock files....

2004-09-24 Thread Matt Sergeant
On 24 Sep 2004, at 14:51, Ara.T.Howard wrote: What are people's views on this? i think it's sufficiently common to merit discussion on best practices at least. More than that, I'm thinking there might be a call for an os_nfs.c that uses this NFS clean locking mechanism. Matt. ___

Re: [sqlite] Lock files....

2004-09-24 Thread Ara.T.Howard
On Fri, 24 Sep 2004, Eddy Macnaghten wrote: There is no way I can guarantee the "nfs" to be good. Also, a mixture of Linux and Windows clients need to be allowed for, I do not know how SAMBA supports the fcntl functionality, or how well it interfaces with the Windows Server or Client locking mecha

Re: [sqlite] Lock files....

2004-09-24 Thread Eddy Macnaghten
On Fri, 2004-09-24 at 14:51, Ara.T.Howard wrote: > On Fri, 24 Sep 2004, Eddy Macnaghten wrote: > > > However, reading the documentation it seems that SQLite is not hot on > > concurrent access through networks, or across platforms, due to the funnies > > of fcntl, or incompatibilities between Wind

Re: [sqlite] Lock files....

2004-09-24 Thread Ara.T.Howard
On Fri, 24 Sep 2004, Eddy Macnaghten wrote: However, reading the documentation it seems that SQLite is not hot on concurrent access through networks, or across platforms, due to the funnies of fcntl, or incompatibilities between Windows and Linux and so on. it works o.k. if your nfs impl is good (n

[sqlite] Lock files....

2004-09-23 Thread Eddy Macnaghten
Hi there I am new to this list, so please excuse me if this has been covered before, or is not the right place for this. I am writing a development language/environment that has a SQL back end. I am (planning to) put in a number of SQL engine connectivities, and SQLite is ideal for the low end t