Hi Geoff,

The blobs where company logos and are intact as
they should have been with FIBPlus

At least the program that prints the logo-nized (sp?) waybills
using the 'modified and backed up' archived look the same.

But we at least seems to pinpoints the culprits maybe :)

Best Regards
Hans

----- Original Message -----
From: "Geoff Worboys" <geoff@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 22, 2010 10:47 PM
Subject: Re: [IBO] development


> Hi Hans,
>
> Intermitted link problems (ongoing) here mean I have not been
> able to respond exactly when I wanted (not to mention that
> nasty subject of paid work ;-).
>
> Analysing the log from your precompiled executable reveals the
> following:
>
> TABLE Records IBO FIB
> INVENTORY 16101 6.375 16.047
> LOGOS 106 21.047 6.063
> MUDCOMPANIES 3058 20.485 7.39
>
>
> Notice the two stand-outs? Those are both tables with large
> binary blobs.
>
> Side Note: How did you create those blobs? When I tried
> to create an equivalent table using Firebird 2.1 I get
> this error from FlameRobin:
> Engine Code : 335544569
> Engine Message :
> Dynamic SQL Error
> SQL error code = -204
> Data type unknown
> Blob sub_types bigger than 1 (text) are for internal use only
>
> I changed the type to 0 and was able to proceed.
>
>
> So the problem appears to be blobs. So I proceeded to copy the
> LOGOS table across to my testing database and ran my two xfer_*
> programs against it.
>
> I did not manage to speed up IBO... but I did manage to to slow
> down FIBPlus:
>
> = = = xfer_ibo = = =
> App Init Time: 16ms
> Object Prepare Time: 78ms
> Records Transfered: 106
> Records Transfer Time: 21328ms
> Transaction Commit Time: 594ms
> Connection Close Time: 0ms
> Application Run Time: 22016ms
>
> = = = xfer_fibplus = = =
> App Init Time: 0ms
> Object Prepare Time: 188ms
> Records Transfered: 102010
> Records Transfer Time: 20187ms
> Transaction Commit Time: 672ms
> Connection Close Time: 0ms
> Application Run Time: 21047ms
>
>
> Isn't that strange? So then I compiled your MaintArcs program
> and it shows LOGOS transfer in just 9seconds.
>
> Hans is there any way to validate the logo blobs being
> transfered to the server? I keep wondering about that subtype
> 512 thing and whether FIBPlus and IBO are behaving differently
> due to the subtype.
>
> --
> Geoff Worboys
> Telesis Computing
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>