Subject | Poor performance using blob fields with .net |
---|---|
Author | berniebialt |
Post date | 2005-05-28T02:55:40Z |
I have an application with stores both notes and images in blob
fields. The application is written in .net and utlizes the .net
provider. When accessing records with no blob contents the performance
is fine, when accessing records with more than 5 associated blob
fields the system performs extremely slow. Is there a sugegsted
segment size for text vs images? Are there limits to the amount of
blobs I should be accessing? Does anyone have any ideas? The network
is Windows/2000 server with a mix of 2000 and XP workstations. The
firebird version is 1.5 as is the .net provider. Help!
fields. The application is written in .net and utlizes the .net
provider. When accessing records with no blob contents the performance
is fine, when accessing records with more than 5 associated blob
fields the system performs extremely slow. Is there a sugegsted
segment size for text vs images? Are there limits to the amount of
blobs I should be accessing? Does anyone have any ideas? The network
is Windows/2000 server with a mix of 2000 and XP workstations. The
firebird version is 1.5 as is the .net provider. Help!