Well, it was painful, but i converted from my attempt at using temp tables to using regular tables. Since this is a multiuser system I need to append each "temporary" table with the name of the user. I finally got it done and the system appear to be working. I will try to load test it tomorrow. One strange thing is that I am not seeing the tables that I created on mysqlWorkbench. Yet the code works. Is this possible?
I am starting to investigate switching over to SQLserver (on RDS). Does CI3 support SQLServer? The main reason is the ability to write/debug stored procedures on sql server. I am checking out the pricing.
proof that an old dog can learn new tricks
