Subject | IBObjects Appending to a blob |
---|---|
Author | spinkstewart |
Post date | 2007-02-09T10:59:56Z |
Hi, I'm creating a large number of blob records (2 million plus) in
Firebird used for word searching. When new words are added I need to
append the ids of the new words to the end of existing blobs. I would
like to use the bsmReadWrite flag in IBObjects' CreateBlobStream to
seek to the end of an existing blob and WriteBuffer the new id number
on the end but I'm not sure of the correct syntax.
At present I open the blob stream in bsmRead mode, copy it to a stream
opended in bsmWrite mode, append to the end using WriteBuffer and then
write the appended stream back. This can be very slow when updating
hundereds of words at a time.
Does anyone have any info on how to use the bsmReadWrite stream or a
better way of appending to a blob stream?
I'm using Delphi v6, IBObjects v4 and Firebird v2.0.
(Sorry, previous posting was sent to wrong group)
Many thanks,
Stewart.
Firebird used for word searching. When new words are added I need to
append the ids of the new words to the end of existing blobs. I would
like to use the bsmReadWrite flag in IBObjects' CreateBlobStream to
seek to the end of an existing blob and WriteBuffer the new id number
on the end but I'm not sure of the correct syntax.
At present I open the blob stream in bsmRead mode, copy it to a stream
opended in bsmWrite mode, append to the end using WriteBuffer and then
write the appended stream back. This can be very slow when updating
hundereds of words at a time.
Does anyone have any info on how to use the bsmReadWrite stream or a
better way of appending to a blob stream?
I'm using Delphi v6, IBObjects v4 and Firebird v2.0.
(Sorry, previous posting was sent to wrong group)
Many thanks,
Stewart.