Sample Header Ad - 728x90

Is it better for performance, to create a separate filegroup for tables that contain blobs?

0 votes
1 answer
63 views
I am currently working on an application that has approximately 500,000 users. Each user has a profile picture averaging around 32KB in size. I am using SqlServer and I want to save these profile pictures in a VARBINARY column in a separate table named ProfilePictures (Very much like what is described here ). Is it better in terms of performance, to create a separate filegroup for this table? Will this improve performance, and if so, how?
Asked by PedroAsking (3 rep)
Jan 26, 2025, 11:26 AM
Last activity: Jan 27, 2025, 02:04 PM