Sounds close. I don't need to compare contents of BLOB's just the BLOB_ID (8
bytes).

Can you send me the source to this privately?

I do have Kylix... Does it matter which version of LINUX I compile it on?

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

----- Original Message -----
From: "Thomas Steinmaurer" <thomas.steinmaurer@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, June 13, 2001 11:17 AM
Subject: RE: [IBO] Replication module update


> Jason,
>
> IB LogManager uses an UDF to compare blobs with a CRC32 algorithm (based
on
> the source of Karsten Strobel). The UDF was written in Delphi and ported
to
> Linux with Kylix. Probably this is something for you?
>
> Thomas
>
> > -----Original Message-----
> > From: Jason Wharton [mailto:jwharton@...]
> > Sent: Wednesday, June 13, 2001 7:31 PM
> > To: IBObjects@yahoogroups.com
> > Subject: Re: [IBO] Replication module update
> >
> >
> > No, I have not. I would like for it to be written in C so that it will
be
> > easy to support the LINUX versions of InterBase too. Is there someone
out
> > there who would kindly write this UDF for me? It would help
tremendously!
> >
> > What it needs to do is VERY simple. Compare the isc_quad that stored the
> > BLOB_ID and tell if they are different or not. It can assume that they
are
> > both "not null" as it is already possible to test if one is null and the
> > other isn't or they both are null.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Thomas Steinmaurer" <thomas.steinmaurer@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Wednesday, June 13, 2001 5:35 AM
> > Subject: RE: [IBO] Replication module update
> >
> >
> > > Jason,
> > >
> > > have you already written this UDF function?
> > >
> > > Thomas Steinmaurer
> > >
> > > > -----Original Message-----
> > > > From: Jason Wharton [mailto:jwharton@...]
> > > > Sent: Wednesday, June 13, 2001 2:08 PM
> > > > To: IBObjects@yahoogroups.com
> > > > Subject: [IBO] Replication module update
> > > >
> > > >
> > > > I have completed the improvements for the handling of BLOB columns.
> > > > Unfortunately I had to make use of a UDF in order to get this to
work.
> > > > For now I am using the FreeUDFLib.dll's F_BLOBBINCMP but it
> > > > doesn't quite do
> > > > just what I want so I will be writing a new one special.
> > > >
> > > > What it does is keep track of when a BLOB column is changed and
> > > > ensure that
> > > > it is only replicated when it has been changed. On the full resync
it
> > will
> > > > do a comparison of the BLOB's and only write a blob to the target
> > > > if it has
> > > > any differences. Previously, due to the nature of BLOB
> > columns it would
> > > > overwrite all BLOB columns. This could drastically impact the
> > > > performance as
> > > > well as bloat the GDB and busy it up doing the garbage
> > collection. Full
> > > > resyncs only need to be done rarely but it is still good that
> > they work
> > > > efficiently.
> > > >
> > > > I believe this module is ready for production usage now... Which, I
> > > > considered the last major piece prior to releasing IBO4 into
> > production.
> > I
> > > > still have a few other items I want to get finished up but they are
> > minor
> > > > issues.
> > > >
> > > > The rest is pretty much docs and marketing only and IBO4 will be
> > released!
> > > >
> > > > Regards,
> > > > Jason Wharton
> > > > CPS - Mesa AZ
> > > > http://www.ibobjects.com
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>