Re: [sqlite] LINKING AND LOADING FTS - on Linux/Ubuntu

>env | grep LD_LIBRARY_PATH; it will display path list. Now use that path and see if your lib is present there or not in that paht. If not add the path(where fst2 exists) to LD_LIBRARY_PATH R u new to unix/linux, i suggest to go through basic of them. regrads

[sqlite] LINKING AND LOADING FTS - on Linux/Ubuntu

Hello, I'm having trouble loading fts2. I modified makefile to create fts2 library on Linux/Ubuntu.I When I attempt to load fts2 using the command select load_extension('fts2'), i get the error shared library not found. ( noticed that it had not created the .so file, only .la file.) What am I

Re: [sqlite] Adding additional operators to FTS3

FTS1 and FTS2 don't provide any grouping operator (i.e. parentheses). e.g. 'pumpkin (onions OR cheese)' Are there plans to provide support for it in FTS3 (or FTS4) ? Klemens - To unsubscribe, send email to [EMAIL PROTE

[sqlite] Exclusive Transactions and Attached Databases

Dear group, regarding the docs, it is possible to attach the same database file multiple times. After doing so, I wanted to begin an exclusive transaction. Unfortunately, this fails ("database is locked") and surprises me as I did not find any notice on this particular situation and possi

[sqlite] Re: Sqlite insertion performance

Kefah T. Issa <[EMAIL PROTECTED]> wrote: I tried the ordered-urls-insert the results were better, but it is still taking progressively longer time as the number of records increases. A fundamental question to be asked here : Shouldn't the time complexity (Big-O) of the insert operation be const

Re: [sqlite] Sqlite insertion performance

Dear Kees and Richard, Much appreciated. I tried the ordered-urls-insert the results were better, but it is still taking progressively longer time as the number of records increases. A fundamental question to be asked here : Shouldn't the time complexity (Big-O) of the insert operation be co

Re: [sqlite] Sqlite insertion performance

I have been struggling with the performance of insertion in sqlite. Here we have a very simple case : A table with an integer autoincrement primary key and a text field that is unique. CREATE TABLE my (id PRIMARY KEY, url); CREATE UNIQUE INDEX myurl ON my(url); My application requires in

Re: [sqlite] Sqlite insertion performance

Hi Kefah, On Sat, 15 Sep 2007 04:43:46 +0300, you wrote: >Thanks Kees, > >In fact using integer instead of string gives very similar results. > >Dropping the unique index constraint and then creating it again when needed >sounds interesting, as insertion without the unique index is satisfactory