Subject | Re: [IBO] Large Blob Insertion |
---|---|
Author | lester@lsces.globalnet.co.uk |
Post date | 2001-04-03T06:24:08Z |
I don't have "BLOB's" that big, but I don't put that sort of
data direct into the database now anyway. The image files
stay in their own directory and just get accessed as
required, and the text stuff is in it's own table in
individual lines so it is more accessable.
That aside, it does sound as if the buffering of data in IBO
is your problem. Once the buffers are allocated is it any
faster. That is, is a second insert any quicker?
Have you tried puting the data in as a parameter in IB_DSQL.
Is that any better?
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
data direct into the database now anyway. The image files
stay in their own directory and just get accessed as
required, and the text stuff is in it's own table in
individual lines so it is more accessable.
That aside, it does sound as if the buffering of data in IBO
is your problem. Once the buffers are allocated is it any
faster. That is, is a second insert any quicker?
Have you tried puting the data in as a parameter in IB_DSQL.
Is that any better?
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services