I have been performing a lot of research on a performance issue we are having and wanted to get input whether it may even be resolvable. Most update/insert commands perform moderately well – around 200 ms or less, which in most cases not a big deal. However, we do have some inserts/updates that contain very large BLOB byte arrays. These can be as large as 100 MB and will take 6+ seconds to save. I have read all the performance recommendations about transactions and connections, but this appears to be a raw encryption issue. If I turn off encryption there is no speed issues. I have a single connection and I have multiple inserts/updates that are sent one at time. The larger the BLOB the longer it takes.
Is there any way to overcome this performance issue?