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/
>
>
>