oledb,insert large file stream,SLOW

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using oledb to insert an uploaded file to access database, for small
files it's pretty fast, but if you go to like a 10 megs file it'll take a
minute, and seems to be quite consistent all the way up to 100megs taking 10
minutes.
I'm doing
cmd.Parameters.Add("@ImgBinary", OleDbType.VarBinary).Value =
saveStream.ToArray();
then executenonquery.

I'm using ASP.NET 2.0, I think it used to be faster for 1.1....but not 100%
sure.

it takes forever, someone help.
 
Well, Jason, there's not much you can do to speed up the process of
inserting binary data into an Access database. However, there is an
alternative. You can put the binary files into the file system, and the file
names only into the database. This way, the database can be used to fetch
the files from the file system.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
You can lead a fish to a bicycle,
but you can't make it stink.
 
mm...thanx, but due to backwards compat. it has to be done this way.
I've just tested directly putting big files into the database and find that
it takes the same amount of time if not longer. All I wanted to know is that
it's not .NET that's slowing it down.

Thanx for reply
 
Back
Top