Hello,
I'm having trouble loading fts2. I modified makefile to create fts2
library on Linux/Ubuntu.
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.)
I do have the LD_LIBRARY set up correctly.
What am I doing wrong?
Thanks in advance
Uma
Uma Krishnan <[EMAIL PROTECTED]> wrote: 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 doing wrong?
Thanks in advance
Uma
Igor Tandetnik wrote: Kefah T. Issa 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
>> constant?
Of course not. It takes O(log N) to find an appropriate place in the
index for every new record (where N is the number of records already
inserted). Also, it generates a lot of disk activity once the index
grows too large to fit in memory cache.
>> I even did a third test where the integer primary key is not auto
>> increment;
>> the same problem is observed.
The id is not a problem: O(log N) is caused by the index on url.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
