Hello there, I am currently working on an email archiving program that is
supposed to copy the entier contents of an email (as downloaded via webdav
from exchange) into a mysql database. This project is being written in C#
with the use of the MySQLDriverCS driver for database connectivity
(originally I was trying oledb with a mysql oledb driver but this didn't
work well). My problem is when I try to insert email attachments of a
"large" size ( greater than about 30K ). What I'm running into is the
runtime on the insert is so long that I just can not afford to wait for the
entire file to be uploaded. My first approch was to try and insert the
entire file at once, but found the insert to take too long. At this point I
decided to try and "chunk" the insert by inserting 1K then updateing the
record with 1K at a time ( then 100B at a time when that took too long). So
far no luck. Does anyone know of any other way to optimise this type of
insert? This seems to be taking way too long. Thanks for any help.