Re: [sqlite] Large DB Performance Questions

here is enough memory in the machine to get the database in to it. I guess since my query is only using one of the indexes and is never reading the table proper that just getting the part of the file that contains the index in to memory would be just as good. Thanks for the suggestion, Mark.

Re: [sqlite] Large DB Performance Questions

On Wed, 2006-06-07 at 00:03 -0500, David Wollmann wrote: > Mark Drago wrote: > > Hello, > > > > I'm writing a web cache and I want to use SQLite to store the log of all > > of the accesses made through the web cache. The idea is to install this > > web cache

[sqlite] Large DB Performance Questions

Hello, I'm writing a web cache and I want to use SQLite to store the log of all of the accesses made through the web cache. The idea is to install this web cache in large institutions (1000-5000 workstations). The log database can grow in size very quickly and can reach in to the gigabytes

Re: [sqlite] sqlite module missing error

On Sat, 2005-10-01 at 00:02 +0530, [EMAIL PROTECTED] wrote: > Hi , > I get this error while trying to install Trac. > > trac-admin /Trac/trac_project_env initenv > Traceback (most recent call last): > File "/usr/bin/trac-admin", line 30, in ? > import sqlite > ImportError: No module named

Re: [sqlite] Including sqlite3 in a GNU project

s on my system that would both need to be updated when a new sqlite is released. In fact, libgda will be adding support for this shortly: http://mail.gnome.org/archives/gnome-db-list/2005-August/msg00048.html Mark Drago. signature.asc Description: This is a digitally signed message part

Re: [sqlite] need to write during a long read

On Thu, 2005-09-08 at 14:36 -0400, D. Richard Hipp wrote: > On Thu, 2005-09-08 at 10:48 -0400, Mark Drago wrote: > > However, it seems that for every rollback that I do there is a file left > > in the directory with the databases. I have 30-something files named > &g

Re: [sqlite] 2.8.16

Richard, You can use 'curl' to download the file instead of wget. So, run the following command instead: curl -o sqlite-2.8.16.tar.gz http://www.sqlite.org/sqlite-2.8.16.tar.gz I don't seem to have the 'md5sum' program installed on the mac that I have here, but getting the md5sum on linux

Re: [sqlite] need to write during a long read

On Wed, 2005-09-07 at 17:20 -0400, Mark Drago wrote: > On Tue, 2005-09-06 at 16:07 -0400, D. Richard Hipp wrote: > > On Tue, 2005-09-06 at 15:49 -0400, Mark Drago wrote: > > > > > 2. I could continue to write to the database in the single thread, but > > >

Re: [sqlite] need to write during a long read

On Tue, 2005-09-06 at 16:07 -0400, D. Richard Hipp wrote: > On Tue, 2005-09-06 at 15:49 -0400, Mark Drago wrote: > > > 2. I could continue to write to the database in the single thread, but > > if the write fails, add the data to a queue and continue. Then, when > > a

RE: [sqlite] need to write during a long read

On Wed, 2005-09-07 at 20:25 +0100, Brandon, Nicholas wrote: > > >take longer than 5 seconds. These reads are being done by PHP using the > >PDO driver for sqlite3. My understanding of the problem is that the PHP > >reader is holding a SHARED lock for longer than 5 seconds, so while the > >C

[sqlite] need to write during a long read

like that. Like I said, I'm interested to know how other people have handled such situations. Any ideas are greatly appreciated. Thanks, Mark Drago signature.asc Description: This is a digitally signed message part