To help isolate if it's actually a library path problem, you might try
using the full path. So, instead of:
select load_extension('fts2');
do:
select load_extension('/path/to/libfts2.so');
Modified for Windows as appropriate (sorry, I mostly use Linux and
static linking). If that works, then it's likely that you have a path
problem. If that doesn't work, it's something else.
-scott
On 9/17/07, Scott Derrick <[EMAIL PROTECTED]> wrote:
> is the fts2 a library?
>
> if so you probably need to put it in a directory that is in the list of
> library directory's. You also may need to run ldconfig to update the
> dynamic linker as the the whereabouts of your new lib.
>
> use "man ldconfig" for the how-to
>
> Scott
>
> Uma Krishnan wrote:
> > 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]
> > -----------------------------------------------------------------------------
> >
> >
> >
> >
>
> --
>
> -
> Rightful liberty is unobstructed action according to our will
> within limits drawn around us by the equal rights of others. I do not
> add "within the limits of the law," because law is often but the
> tyrant's will, and always so when it violates the rights of the individual.
>
> Thomas Jefferson
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----------------------------------------------------------------------------
>
>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
