One thing that might be possible is to replicate the data to be searched to
an external (isolated) copy and then when you want to regenerate the indexes
you can pause the replication and let things queue up while the regeneration
is taking place. Once done, turn on the replication again.

Or, you can roll your own...

Neither probably sounds that inviting....

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Daniel Bertin" <daniel@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, January 26, 2001 1:27 PM
Subject: Re: [IBO] IBO connects


>
> What would you suggest I do to resolve this impass I'm in. this
application
> is 24X7 and has from 15 to 20 users at any one time.
>
> which other search component can I use? rubicon searches all the fields
and
> the blobs and is quite fast. but this make/update is a problem for me?
>
>
>
>
> At 01:01 PM 26/01/2001 -0700, you wrote:
> >Rubicon makes it so that you have to take your database down to rebuild
an
> >index?
> >
> >What are they, static or something? Doesn't he have a real-time mechanism
to
> >keep the indexes up to date?
> >
> >I know the full text search stuff I wrote is real-time... I couldn't use
> >Rubicon because it didn't do some of the things we needed.
> >
> >Regards,
> >Jason Wharton
> >CPS - Mesa AZ
> >http://www.ibobjects.com
> >
> >
> >----- Original Message -----
> >From: "Daniel Bertin" <daniel@...>
> >To: <IBObjects@yahoogroups.com>
> >Sent: Friday, January 26, 2001 12:50 PM
> >Subject: Re: [IBO] IBO connects
> >
> >
> > > Hi Jason,
> > > the backup is fine with IB but, what I want to do needs exclusive
access
> >to
> > > the database. I'm using Rubicon search and need to update a words
table.
> > > This is the exact error
> > >
> > > ISC ERROR CODE 335544345
> > >
> > > ISC ERROR MESSAGE:
> > > lock conflict on no wait transaction
> > > unsuccessful metadata update
> > > object WORDS is in use.
> > >
> > > It was suggested to backup the database, do the update and restore the
> > > updated database over the original one. for the overwrite don't I need
to
> > > shutdown the database?
> > > what I was wondering, what happens to the connection while I'm shuting
> >down
> > > and starting up again.
> > >
> > > Does this make sense or is there another way for me to get rid of
this
> >error.
> > > Thanks
> > > Daniel
> > >
> > > At 11:42 AM 26/01/2001 -0700, you wrote:
> > > >Try the post. Why shut people out for a backup?
> > > >
> > > >Jason Wharton
> > > >CPS - Mesa AZ
> > > >http://www.ibobjects.com
> > > >
> > > >
> > > >----- Original Message -----
> > > >From: "Daniel Bertin" <daniel@...>
> > > >To: <IBObjects@yahoogroups.com>
> > > >Sent: Friday, January 26, 2001 11:50 AM
> > > >Subject: [IBO] IBO connects
> > > >
> > > >
> > > > > Hi all,
> > > > >
> > > > > How would I, Using IBO check if the connection is valid before I
post
> >my
> > > > > records to the database.
> > > > >
> > > > > by this I want to shutdown the database in order to do a backup
and
> > > >restore
> > > > > but I have 15-20 users live on this database. I cannot get them to
> >logout,
> > > > > so I figured I would code a check to make sure they are connected,
> >just
> > > > > before the post, if not connected try again until they are
connected.
> > > > > How would I do this?
> > > > > I,m using delphi and IBO for the client, linux and IB SS for the
> >server.
> > > > >
> > > > > Can someone give me a direction on how to accomplish this?
> > > > >
> > > > > Thanks
> > > > > Daniel
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
>