Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lionofdezert
Aged Yak Warrior
885 Posts |
 Posted - 2008-06-26 : 09:07:23
|
| According to my client, they have million of images to save in database. My question is :How much images i can save in sql server 2005 database ?What about PERFORMANCE ISSUES, after saving huge binary data ? |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-06-26 : 11:39:07
|
| SURE, there is going to be performance issues if you save images into the Database Directly.the column type should be a BLOB Type varbinary(MAX) (SQL 2005).Cannot thet Just Store the Images at another location just a link/path to these images in the Database.Which Edition are we talking about. STANDARD / ENT.how much RAM/Processors etc(HARDWARE).List the Things and i we can discuss.Maninder |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2008-06-27 : 01:04:50
|
| 1. We cann't save images to another location (no link method will be used). We have to save images in Database Directly.2. Enterprise Edition will be used3. Clint is ready to purchase Quad-Core Intel® Xeon® Processor (2.33 GHz (2U passive, 8M Cache, 1333 MHz FSB) 4GB RAM4. We have to replicate our images data between (Upto 100 nodes) ??? |
|
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-06-27 : 16:36:09
|
| REPlicate = copy the Database or is it in REplication or send the Results to clients.What is the size of the Database.Sure, if you save a million Images in the Database, it is going to get a performance hit at a Point in time. What is the Datatype used to store BLOB.Maninder |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 00:01:15
|
| Replicate blobs to 100 nodes? Why can't just query server directly? |
|
|
|
|
|
|
Binary Data & Sql Server 2005 Performance