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 |
|
vijay kumar
Starting Member
2 Posts |
 Posted - 2007-11-21 : 05:40:30
|
| I have SQL Server 2000 database involving voluminous data spread across different locations in a state. The database involves lot of transactions. The database involves tables storing photo images and thumb impressions along with the textual data and other needed information in a single table. I have a application accessing and updating about 5 tables and reading most of the master tables. I need a strategy to design the database such that performance improves. Once the photo and thumb are inserted for a particular party it is not required for retrieval immediately at any circumstance. In this scenario how should I design the database and keep data volume in check. Can I archive photo and thumb impressions in CDs. Will it be reliable and feasible. Please clarify on this issue. Please share your valuable experience. Only insertions involved in the partyinfo table having Photo and Thumb impressions. Later the table is only used to fetch the data of party other than Photo and thumb. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-21 : 06:05:08
|
| moved from article discussion_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 05:14:22
|
| What's wrong with archiving it to a seperate table on its own filegroup? Why would you want to store this information on CD? |
|
|
|
vijay kumar
Starting Member
2 Posts |
Posted - 2007-11-27 : 05:13:36
|
quote:
Originally posted by RickD
What's wrong with archiving it to a seperate table on its own filegroup? Why would you want to store this information on CD?
Thanks Rick for your reply. Can I isolate Photo image columns and Thumb impression image columns place in a separate database and simultaneously access both the database in the application. Is it possible and will there be any overheads OR shall I create a child table in the same database having only these two column and primary key to access them. |
|
|
|
|
|
|
Please share your valuable experience