Post reply

Ntext/Image, do they effect server performance ?

  • January 8, 2009 at 8:41 am

    #204840

    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..

  • January 8, 2009 at 8:55 am

    #923402

    The general recommendation for BLOB's in SQL Server is to only store them on the server is they are relatively small and you are dealing with larger files. For larger files most people recommend that the application store them to a network share and that you only store the path in SQL Server (varchar/nvarchar).

    I'm sure making this change would have a pretty big impact on your application and require some pretty major changes.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply