By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,825 Members | 1,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,825 IT Pros & Developers. It's quick & easy.

"Large" inserts into mysql

P: n/a
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.
Nov 16 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.