Fast retrieval of BLOB data from database



  • 1. How To Set Values When adLockReadOnly
    I have a recordest from a stored proc that I want to update locally, not to the database. The normal statement fails: rs("field1").value = "X" 'fails I assume this is because the locktype is adLockReadOnly . All attempts to change this have failed. I assume that adLockReadOnly is standard when the rs is derived from a stored proc. Is there any way to set field values in this rs? No database update is required. Many thanks, Jeb jbushell<at>
  • 2. Managing a Database using Word / IIS
    I have a fairly ambitious client who would like to offload the management of intranet content to other individuals in the organization. For the project to be successful, the data management must be as painless as possible. Accordingly, the ideal interface for data input is Microsoft Word, as most users are extremely comfortable working with it. I would like to be able to create word templates/forms which are dynamically populated with data from an database, then downloaded to the client PC. Once the data is updated, I would like the user to upload their files back to the server, which will in turn update its database and maintain an audit-trail of all changes. Can this be done? I'm assuming that if I install Office on the server, it would be feasible using the office API, but I would love to be able to do this without office on the server.. any hints / suggestions would be HUGELY appreciated! Thanks, Aaron
  • 3. new to ado
    hi i have ms access database and i am using vb and ado to connect with ms access whati wana do is to open access file exclusivel as i learned that when you open file exclusive then no open can open that file simultancly. but i dot know how to open file and lock it for all user or to check any other is using that file already i am suing that database on network

Fast retrieval of BLOB data from database

Postby cHVydmk » Sat, 12 Mar 2005 05:17:04 GMT

Hello All,
I am trying to retrieve BLOB data stored in Oracle 9i database using ADO 
streams. The saving of BLOB data to the database is fast, but the retrieval 
from the database is very slow. It takes more than 1 minute to retrieve a 6 
MB file.

I have also tried using AppendChunk/GetChunk methods, but there is no 
difference in the performance. 

Can anyone please suggest an alternative fast method of huge (around 100MB) 
of BLOB data from the database?

Thanks in advance.
Purvi Dholakia

Return to ADO


Who is online

Users browsing this forum: No registered users and 89 guest