Hello Gurus,
We have an application that stores large amount of Image data e, the Max length is in excess of 100k and average is about 40k , and the table contains about 400,000 rows(and growing).
We observed that when running the following query:
Select Max(datalength(Drawing)) from ImageData
The Spid get blocked by it self but unblocks itself once the query is complete (after about 6 minutes).
We believe retrieving/inserting Image data incur heavy performance penalty ,
The IO Queue length grows whenever the Image data is retrieved or inserted .
Is there a better way to handle Image data(Like Oracle Bfile type) and how we may port the current image data handling with minimal impact to our existing application.
Appreciate your advise..