Subject | Blob fields |
---|---|
Author | Christian Kaufmann |
Post date | 2006-06-30T07:44:53Z |
Hi,
I have some performance problems with an application, where I store
geometries in blob fields. Reading 12'000 records takes very long and
I'm looking, how to speed it up. The technology we use is:
- Delphi 6
- dbExpress, driver from upscene.com
- Firebird 1.5, server Win32
One thing is, that most of the blob fields data has a size of 100-1000
bytes. So my question is, what exactly does the "SEGMENT SIZE" in the
declaration of the blob field? Should I change that to another value
than the default of 80?
Will Firebird 2.0 be different regarding blob fields and performance?
cu Christian
I have some performance problems with an application, where I store
geometries in blob fields. Reading 12'000 records takes very long and
I'm looking, how to speed it up. The technology we use is:
- Delphi 6
- dbExpress, driver from upscene.com
- Firebird 1.5, server Win32
One thing is, that most of the blob fields data has a size of 100-1000
bytes. So my question is, what exactly does the "SEGMENT SIZE" in the
declaration of the blob field? Should I change that to another value
than the default of 80?
Will Firebird 2.0 be different regarding blob fields and performance?
cu Christian