I am not a strong expert in databases at this level, so I was wondering the following.
A database I am currently working on has a large TEXT field where potentially hundreds of megabytes are stored in each row. I understand this is not optimal design but it predates me and I can't change it now.
The insertion of the data happens with a single SQL query INSERT INTO, which of course results in a gigantic query. I was wondering the following:
- Is INSERT the only option in this case when submitting large blob of data? maybe there's a SQL extension to handle such large transfers that is better optimized.
- Having a single query of this size obviously requires that the whole transfer of these hundreds of megabytes goes smooth without any network issue for the whole duration of the transfer. How resilient is this to network issues, and can it be restarted in case of failure without having to reissue the whole query again (and therefore restart the whole transfer from scratch)?
I am using the latest MySQL, but I wonder also about other databases for personal awareness.