@Omini yes, I just tried this way too, it still seems to cut-off at 1,000,000 bytes, so it wasn't related to breaking due to content etc, it still seems to be a data length / quota memory problem
Great thanks, will do a bit more reading. I'm not sure what advanced DB settings BAS even has for this kind of thing. TBH I will probably just create a work around and start using a schedule to run with 1 thread regularly until a condition is met. Then the DB is updated in real time and massively minimises the odds of a single row being selected by two scripts. Bit of a pain, but I can't see any options in BAS so far to implement what you're discussing! Best Regards