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
Last activity: Jan 27, 2025, 02:04 PM