This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 56.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Supprimer l'alerte|Modifier|Type de modification
Question
Vous ne pouvez pas voter pour votre propre billet.
0
Hello
I'm Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server Express 2014, the problem is when I store the image with the size 200ko, I found that the size change to 3000ko, so the size of the file becomes 15 times bigger than his real size?
Is it normal?
or there is anything I can do in the configuration to make compression of files?
Best Regards
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
How are you determining that the file size changed?
i have checked it in the folder of file stream : C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\test_filestream\7367e152-4a90-4576-b516-999b38d71d0d\83bd3fdf-90fe-4a23-8ba5-47a5c5a4707b
anonymous usere-msft thank you sooo much. your remark is correct, it was converted to BMP for that size change I have changed the code to :
FDQuery1.ParamByName('image').LoadFromFile(aFile, ftBlob);
and I have the same size
the language is Delphi (Pascal)
thank you again
How did you add the file do the database? Plain insert or OpenSqlFilestream?
Not that it would matter, you will get the same amount of bytes in either case.
You may be looking at another file. Items stay around in the filestream folder, even if the row it came from has been deleted. No, it does not stay for ever, but a log backup has to be taken, before garbage collection can set it.
this is my procedure to add the files :
procedure TForm1.Button1Click(Sender: TObject);
var
MStream : TMemoryStream;
begin
MStream := TMemoryStream.Create;
try
FDQuery1.SQL.Text := 'INSERT INTO clients (ID, image) VALUES (newId(), :image)';
image1.Bitmap.SaveToStream(MSTream);
MStream.Seek(0,0);
try
FDQuery1.ParamByName('image').LoadFromStream(MStream, ftBlob);
FDQuery1.ExecSQL();
except
on E: Exception do
ShowMessage('Error on ExecSQL! ' + e.Message);
end;
MStream.Free;
finally
FDQuery1.Close;
end;
end;
I don't know what language/framework that is but test with a file. If Bitmap.SaveToStream saves the raw bitmap instead of a compressed JPG, PNG, etc, file that could explain the apparent size difference.