November 17, 2009 at 3:26 am
Hi Friends,
We are working for warehouse project , now we have to add one image column in one of that table, so we can get the image data from pbulisher and we can consume that.
Now the question are ,
> use of image datatype degrades the performance
> can we use image field in where clause, or can we use image field in any kind of comparision or in binarychecksum(*)
>can we bulk insert the image from flatfile, i dnt know is it the valid questions.
So If you guys can share your experience or any link whcih can guide us to take the call.
Thanks,
Mithun
November 17, 2009 at 5:18 am
If you're working with SQL 2005 (you should if you're on this section of the forum :)) or later use (var)binary / varbinary(max). See BOL for details.
Before deciding whether to store images in the database or in the file system, be sure to read
- both the article and the pdf document recommended.
I'm not sure what do you mean by "bulk insert the image from flatfile"...
November 17, 2009 at 11:23 pm
Thanks for the pointers, the articles are good but nothing much said on performance side, as we are going to have it in datawarehouse so is it feasible to store in database?
Mithun
November 19, 2009 at 4:30 am
The document recommended contains the performance related discussion.
November 23, 2009 at 3:42 am
Google "to blob or not to blob" for a paper giving good performance advice.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply