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