Thx Insite. I managed to get the temporary tables working. Here are some important points for others.
1. There is no way to see what temp tables exist.
2. Errors in sql on creation of temp tables don't display.
3. The lack of tools makes this trial and error.
As of now it is working fine. I am having trouble with S3 under load. About 10% of the time the bucket is not found and I get a 500 server error. Not sure how to fix this.
(10-02-2022, 04:26 AM)richb201 Wrote: Thx Insite. I managed to get the temporary tables working. Here are some important points for others.
1. There is no way to see what temp tables exist.
2. Errors in sql on creation of temp tables don't display.
3. The lack of tools makes this trial and error.
As of now it is working fine. I am having trouble with S3 under load. About 10% of the time the bucket is not found and I get a 500 server error. Not sure how to fix this.
I use koolreport and was not able to get kr to directly use images on s3. So when a user logs in I download their images to the server. Not the greatest solution.
proof that an old dog can learn new tricks
