RE: [sqlite] Version 3.3.9

Good work Dr. Hipp and thanks for Sqlite. One question comes to mind when looking at the changes implemented. In particular.. ("VACUUM uses a temporary file in the official TEMP folder, not in the same directory as the original database") Would doing this not pose a problem when the process

Re: [sqlite] Why is the sqlite3.def file missing in v. 3.3.8 package ??? (SQLite3 source code preprocessed for Win32)

--- Klemens Friedl <[EMAIL PROTECTED]> wrote: > All SQLite3 Source code package (preprocessing for Win32) except the > latest one (v. 3.3.8) have come with "sqlite3.def" file which I used > to build sqlite3.dll (dynamic link library). > > Why hasn't the "sqlite3.def" file been added? I suspect

Re: [sqlite] odd indexing behavior

--- michael cuthbertson <[EMAIL PROTECTED]> wrote: > Thanks for the response, Joe. > Unfortunately, since I have no way of knowing a priori what the relative > number of returned > rows is (without doing another query), using the plus is not really a > work-around, it is > a "don't use indexes"

Re: [sqlite] Calling ATTACH internally

> ** The lock byte is obtained at > ** random so two separate readers can probably access the file at the > ** same time, unless they are unlucky and choose the same lock byte. > "can probably access the file at the same time" is better than "can't" > access, but there is no > guarantee. > Does

Re: [sqlite] SQLite on tempfs

The performance is pretty much the same as using a :memory: database. Indexes can still be useful on memory databases to speed up queries. It depends on your schema/data. Try it and see. --- Cesar Rodas <[EMAIL PROTECTED]> wrote: > I am wondering if will be faster if i create a SQLite DB in a

Re: [sqlite] Odd indexing behavior, 2nd request for help

--- michael cuthbertson <[EMAIL PROTECTED]> wrote: > Hello. > I sent this 2 days a go but have not received an explanation or solution. As I explained to you a couple of days ago in this post http://www.mail-archive.com/sqlite-users%40sqlite.org/msg20802.html that's the nature of indexes - they

Re: AW: [sqlite] sqlite performance, locking & threading

Work on turning "reasonable" into "adequate" or "good" and it will help you get an intuitive feel for the design of programs such as yours. Then your programs will be simple, fast and robust, as Einstein counselled - "Make it as simple a possible, but no simpler". I also suggest that you take

[sqlite] Linking error with sqlite3SrcListAddAlias...

Hi, I'm using MS VS 2005 (SQLite 3.3.9) and having problem re-building the component. I've just included all the source code inside my project and compile. With version 3.3.8 it works fine, but with current (3.3.9) it's giving me missing sqlite3SrcListAddAlias. Any files should be included

Re: AW: [sqlite] sqlite performance, locking & threading

John, I have a reasonable understanding of the PC architecture, and more appropriately the architecture which the operating system presents to software. The PC may be a serial device, but a modern operating system with its multitasking shcheduler attempts to emulate a non serial environment.

Re: [sqlite] sqlite performance, locking & threading

Bill, Thanks for the description, thats pretty much how i designed the index, but with a few modifications. The filesystem becomes the tree structure which is indexed by a hash of the original document url. It works like a big hashtable so its quite scalable. > Sorry if this has been

Re: [sqlite] Odd indexing behavior, 2nd request for help

michael cuthbertson wrote: To summarize, in this query with indexes on most columns, SQLite will only use time1 index and is slower doing so. Could someone please explain to me why this happens? Michael, You may want to check out the ANALYZE command. It creates an internal table with

Re: [sqlite] SegFault on threadtest2.c using version 3.3.9

Ken <[EMAIL PROTECTED]> wrote: > threadtest2 generated a segmentation fault as well as an illegal operations > when running against version 3.3.9 (in 32bit mode). > > I did compile using --enable-threadsafe. > > Does this mean this version is not threadsafe? threadtest2.c is

RE: [sqlite] Odd indexing behavior, 2nd request for help

Hi Michael, Regarding: "I sent this 2 days a go but have not received an explanation or solution. Anybody had this problem?" Joe Wilson tried providing some explanation on 2 January: "Hitting both the index and the underlying table can often be slower than just doing a table scan if you have

[sqlite] Odd indexing behavior, 2nd request for help

Hello. I sent this 2 days a go but have not received an explanation or solution. Anybody had this problem? Hello and Happy New year! I have an indexing problem with a very simple query. The correct index is not used or no index is used, according to Explain Query Plan. In the following query,

[sqlite] Re: Compound index or multiple indexes?

Alberto Simões <[EMAIL PROTECTED]> wrote: Hi I am using SQLite to store bigrams, trigrams and tetragrams. Let's look for one of the tables: CREATE TABLE trigrams (word1 INTEGER, word2 INTEGER, word3 INTEGER, occs INTEGER,

[sqlite] SQLite on tempfs

Hello I am wondering if will be faster if i create a SQLite DB in a tempfs, but with out index?

[sqlite] Compound index or multiple indexes?

Hi I am using SQLite to store bigrams, trigrams and tetragrams. Let's look for one of the tables: CREATE TABLE trigrams (word1 INTEGER, word2 INTEGER, word3 INTEGER, occs INTEGER, PRIMARY KEY

Re: [sqlite] Version 3.3.9

> I'm curious to know what your situation is. I am doing commercial software that provides an Excel frontend (.xla with some VB6 ActiveX dll's) for a medical Interbase database. I am in the process of doing a major re-write, moving away from array manipulations and text file SQL to doing all the

Re: [sqlite] Version 3.3.9

[EMAIL PROTECTED] wrote: > Looks it has got faster in my particular situation. There were a few minor enhancements to the optimizer, but nothing major. Perhaps one of those enhancements fell right where you needed it. I'm curious to know what your situation is. -- D. Richard Hipp <[EMAIL

Re: [sqlite] Version 3.3.9

Congratulations D. Richard Hipp. Thank for give us SQLite On 04/01/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Looks it has got faster in my particular situation. Thanks for that. RBS > SQLite version 3.3.9 is now available from the SQLite website > >http://www.sqlite.org/ >

Re: [sqlite] Version 3.3.9

Looks it has got faster in my particular situation. Thanks for that. RBS > SQLite version 3.3.9 is now available from the SQLite website > >http://www.sqlite.org/ >http://www.sqlite.org/download.html > > The more important change is a fix for an obscure bug that can > lead to database

[sqlite] Version 3.3.9

SQLite version 3.3.9 is now available from the SQLite website http://www.sqlite.org/ http://www.sqlite.org/download.html The more important change is a fix for an obscure bug that can lead to database corruption on multi-processor systems. Other important changes include the addition of

[sqlite] Calling ATTACH internally

Hi I need SQLite to be able to acces several tables at the same time. I'v decided to do this by creating a new database for each table. So far I'v changed sqlite3StartTable() function - it calls attachFunc() and then changes name to name.name. It worked - master database is not changed, and

Re: [sqlite] Error during compilation of sqlite-3.3.8

Dori, I've just logged into the Debian box where I last did any work on this. On that machine (in .../sqlite/bld) I had to issue ../configure --with-tcl=/usr/lib/tcl8.4/ to get configure to work. I have tcl8.3 and 8.4 on my machine so as you suggest, you might have to use /usr/local/lib

Re: [sqlite] Error during compilation of sqlite-3.3.8

Dori Meshulam wrote: I found tcl.h under '/usr/local/include', but when I run make after "configure --with-tcl=/usr/local/include" I get the following error: "checking for Tcl configuration... configure: error: /usr/local/include/tcl.h directory doesn't contain tclConfig.sh" tclConfig.sh is

Re: AW: [sqlite] sqlite performance, locking & threading

If Emeroson intuitively understood the essential architecture of the PC he is using he would not be having difficulty with his concept of how to use it. It is essentially a serial device, multi-tasking device and parallelism in the forms of threading and multi processing is a sophistication

RE: [sqlite] Error during compilation of sqlite-3.3.8

Martin, Thanks for your response. I found tcl.h under '/usr/local/include', but when I run make after "configure --with-tcl=/usr/local/include" I get the following error: "checking for Tcl configuration... configure: error: /usr/local/include/tcl.h directory doesn't contain tclConfig.sh"

Re: [sqlite] fts1 and word boundary

"Ohad Eder-Pressman" <[EMAIL PROTECTED]> wrote: > i have an fts1 table populated with, errr, text. > lets say one field has this text "big monster". > > this sql query: text match 'ter' doesn't return this item. if i do a text > match 'monster' i do get this item. > > does fts1 support this

[sqlite] fts1 and word boundary

i have an fts1 table populated with, errr, text. lets say one field has this text "big monster". this sql query: text match 'ter' doesn't return this item. if i do a text match 'monster' i do get this item. does fts1 support this behavior i need ?

Re: [sqlite] calculate age (off topic)

Jay Sprenkle wrote: > LOL! You should look at a function to determine if a day is a holiday. > Talk about ugly! In some places you literally need to know the weather > and the phase of the moon! > > -- [EMAIL PROTECTED] ~/movie]$ pom The Moon is Waning Gibbous (100% of Full) [EMAIL PROTECTED]

[sqlite] Error during compilation of sqlite-3.3.8

Hi, My name is Dori and I'm trying to compile sqlite-3.3.8 on UNIX HP machine after downloading sqlite-3.3.8.tar.gz. I got the following errors while running 'make test' command. I couldn't find 'tcl.h' file. cpp: "../sqlite-3.3.8/src/test1.c", line 19: error 4036: Can't open include file

[sqlite] coldfusion

Hi, I'm using Coldfusion MX 6 and I'm trying to connect to an sqlite3 database. Does anyone know what's the best way to do this? Tnx in advance

Re: [sqlite] sqlite performance, locking & threading

Emerson Clarke wrote: The indexing process works like this. 1.) Open a document and parse its contents. 2.) Look up records in the first database based on the contents of the document, updating records where appropriate and inserting new ones. 3.) Transforming the document based on what was

[sqlite] installing sqlite

hi, I am using Eclipse 3.2.0 and I am intrested in how to install sqlite drivers for my eclipse. I am new at this, so every advice would be very helpful to me. -- View this message in context: http://www.nabble.com/installing-sqlite-tf2918531.html#a8156277 Sent from the SQLite mailing list