Re: [sqlite] Thinking about using SQLite on a windows file share with multiple client connections to it (is this a good idea?)

On Wed, Jul 13, 2011 at 3:28 PM, Shawn Bice wrote: > > Hello, I'm thinking about using SQLite on a windows file share having > multiple clients reading and writing to the database. I think I understand > the gist of how this works via some really good docs on the SQLite

Re: [sqlite] Thinking about using SQLite on a windows file share with multiple client connections to it (is this a good idea?)

On 13 Jul 2011, at 11:28pm, Shawn Bice wrote: > I believe we will have moderate multi-client traffic and I was hoping to gain > some additional perspective from folks who have far more experience using > SQLite in this config. If your intention from the ground up is to do lots of concurrent

Re: [sqlite] Compiling sqlite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/13/2011 10:56 AM, Jan Hudec wrote: > In my experience, the .o files are significantly larger than the resulting > binary. The size command will tell you how big the code (aka text), data and zero initialized data (aka bss) are for object or

Re: [sqlite] Integrate page-level locking into main SQLite like BerkleyDB's SQLite ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/13/2011 03:06 PM, Samuel Neff wrote: > The BerkleyDB backed version of SQLite from Oracle supports page level > locking. Apparently this is where the real performance gains come from, not > swapping out the back-end. That only helps with

[sqlite] Thinking about using SQLite on a windows file share with multiple client connections to it (is this a good idea?)

Hello, I'm thinking about using SQLite on a windows file share having multiple clients reading and writing to the database. I think I understand the gist of how this works via some really good docs on the SQLite site but from what I can tell, it sounds like this isn't a canonical scenario for

[sqlite] Integrate page-level locking into main SQLite like BerkleyDB's SQLite ?

The BerkleyDB backed version of SQLite from Oracle supports page level locking. Apparently this is where the real performance gains come from, not swapping out the back-end. http://www.oracle.com/technetwork/database/berkeleydb/downloads/index.html Are there any plans to add page-level locking

Re: [sqlite] Compiling sqlite

On Tue, Jul 12, 2011 at 17:37:57 +0300, Baruch Burstein wrote: > The website (http://www.sqlite.org/about.html) says that sqlite can be > compiled to under 300K. I am using mingw32, and with no configuration did I > manage to get sqlite3.o below 400k. What compiler/compiler options are used > to

Re: [sqlite] Attach file/disk DB to memory DB

> If I was to attach a database located in a file on disk to a database located > in memory, would the file DB be loaded in memory too, or would its usage > remain disk-based? Its usage would be the same as if you open a new connection to that database file, i.e. disk-based (barring the page

Re: [sqlite] Attach file/disk DB to memory DB

On 07/13/2011 10:18 PM, Alexandre G wrote: > > If I was to attach a database located in a file on disk to a database located > in memory, would the file DB be loaded in memory too, or would its usage > remain disk-based? It remains on disk. Whether or not the main database is in-memory does not

[sqlite] Attach file/disk DB to memory DB

If I was to attach a database located in a file on disk to a database located in memory, would the file DB be loaded in memory too, or would its usage remain disk-based? I need to know because we want to keep memory usage to a minimum. Note that the disk is read-only. Thanks -- View this

Re: [sqlite] Why does analyze make this go faster?

The table A3Test7D4_E is deleted and re-written every time. The table ENTRY_ATTRIBUTES is large table (millions of records) and it will need an analyze when made first time. Doesn't look cache is the reason for this behaviour here. RBS On Wed, Jul 13, 2011 at 1:44 PM, Stephen C

Re: [sqlite] Can a sys admin control temporary file location without changing the source code?

On Mon, Jul 11, 2011 at 01:18, H. Phil Duby wrote: > On Sat, Jul 9, 2011 at 23:22, Stephan Beal wrote: > >> On Sun, Jul 10, 2011 at 4:25 AM, Tom Browder >> wrote: >> >> > sqlite db files and making sure that directory is

Re: [sqlite] Memory leak?

Some mistakes... * I use also PRAGMA cache_size=100 but the some problem On Wed, Jul 13, 2011 at 3:12 PM, Anze Rozman wrote: > Hi! > > I have an application which inserts into database most of the time. Problem > is that memory is decreasing. Aplication is in java and I

[sqlite] Memory leak?

Hi! I have an application which inserts into database most of the time. Problem is that memory is decreasing. Aplication is in java and I use Werner's sqlite wrapper - http://www.ch-werner.de/javasqlite/ (because of J2ME). I use method

[sqlite] ANN: AnySQL Maestro 11.7 released

Hi! SQL Maestro Group announces the release of AnySQL Maestro 11.7, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (SQLite, PostgreSQL, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at

Re: [sqlite] Why does analyze make this go faster?

What happens when you let the query run the first time, delete the records, then re-run the query? If the same length of time is spent (50 seconds) then I'm at a loss. If the shorter length of time happens, I'd say blame caching. On 07/13/2011 06:00 AM, Bart Smissaert wrote: > Have the

Re: [sqlite] FTS3: synonyms dictionary and tokens length

On 07/13/2011 05:05 PM, Alexey Pechnikov wrote: > With synonyms dictionary the result token length can be more then > original token length. > Is it problem for current realization of FTS? I don't think so. If it is, it's a bug. Dan. ___ sqlite-users

[sqlite] FTS3: synonyms dictionary and tokens length

With synonyms dictionary the result token length can be more then original token length. Is it problem for current realization of FTS? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Database handle access from tokenizer module (stopwords table support)

I want to add stopwords table support for ICU tokenizer but there is no database handle access (icuOpen). Any ideas? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Why does analyze make this go faster?

Have the following query: INSERT INTO A3Test7D4_J (PATIENT_ID, ENTRY_ID, READ_CODE, TERM_TEXT, ADDED_DATE, START_DATE, NUMERIC_VALUE, TYPE_SPECIFIC_INFO) SELECT E.PATIENT_ID, E.ENTRY_ID, E.READ_CODE, E.TERM_TEXT, E.ADDED_DATE, E.START_DATE, EA.NUMERIC_VALUE, EA.TYPE_SPECIFIC_INFO FROM A3Test7D4_E

Re: [sqlite] Data type of the blob returned by matchinfo()

On 07/13/2011 04:57 AM, Abhinav Upadhyay wrote: > Hi, > > Quoting the ranking function given in the appendix of the FTS3 > documentation page (http://www.sqlite.org/fts3.html#appendix_a) > > static void rankfunc(sqlite3_context *pCtx, int nVal, sqlite3_value **apVal){ >int *aMatchinfo;