I am very disappointed in the lack of responses. I spent 4 or 5 years writing this code and now it seems that there is a bug in CI3 dealing with TEMP files and not a single response. I had never heard of temporary files until I was told of their existence up here. Based my architecture on them. Now I discover in load testing that they don't work. But clearly there is either a problem with Temp files across "sessions" or a general CI bug in creating them. I can create one fine in mysqlWorkBench which makes it pretty clear that the issue is with CI3.
proof that an old dog can learn new tricks