Timeline for Should I use BLOB or Tables for storing large data?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 22, 2015 at 2:42 | comment | added | Kevin | @ddalton: That's easy. Just put your files under version control or a CMS and you have transactionality. | |
| May 21, 2015 at 14:00 | comment | added | codedabbler | All actions have to be transactional, since there are other updates within the RDBMS that occur as part of the upload. So this cannot be put in a non-transactional data source. There is at least one main operation where we need to load all the data or BLOBs and process it. This operation can be done asynchronously, so a BLOB is seems feasible. But storing it as rows gives us a lot more flexibility with future enhancements that would need to slice and dice it. But our current focus is on improving the performance. | |
| May 21, 2015 at 11:39 | comment | added | Ewan | I Agree, I mean the excel doc will have 100m xml nodes in it | |
| May 21, 2015 at 11:18 | history | answered | Phill W. | CC BY-SA 3.0 |