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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-18 : 08:33:20
|
Corbie writes "We are working on a database for people to store text and images in the same table. We have enlisted AspUpload by Persits software, as well as AspJpeg, to upload images and convert to thumbnails. I might be an idiot, but after working with these components, it seems to me that they are being stored as Blobs in the database. The documentation I have says we are using ADO objects, which renders the underlying file data in the Safe-array-of-bytes format compatible with ADO recordset fields. I read on your site about people wanting to store images in the database, and that you don't recommend it. My questions are:
1. Even though the picture field is set as image, aren't I storing these as blobs with the following code:
rsADO("IMAGE4").Value = File.Binary
And then retrieving them via a Send.Binary command.
2. For a site focused on just one city, we aren't expecting "Terra Data" amounts of images, but we hope there will be a couple of thousand in @ 16 tables. Is this method doable? Because...question #3
3. Right now, I have this working with 4 tables, each with around 5 records in them. With all the testing, I've noticed a performance difference as the # of records increases. Duh. I have been deleting test records daily, but today the thumbnails are not loading all the way. The rest of the record pops right up, but both the thumb and image get hung up." |
|
|
|
|
|
|
|
Blobs in 7.0