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 |
|
BitShift
Yak Posting Veteran
98 Posts |
 Posted - 2007-05-03 : 18:13:41
|
| An application im working on pulls image data from sql server 2005, creates a memory stream and puts several images into a single pdf document before streaming it back to the client browser. It works, but its slow and is probably ripe for peformance tuning. One thing im looking at is to replace single procedure calls for each image into one stored procedure call that fetches all images. If nothing else, it should reduce network traffic. There is some other processing going on, but thats the first suspect area.thoughts ? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-03 : 18:23:02
|
| that should help.any way you can store the images outside of the db? that would save you the stream from db part._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-04 : 06:17:20
|
| http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Fetching images from sql