Comments by Member 15071189

Member 15071189 13-Feb-21 12:24pm View

I appreciate you sharing your insight. The first solution did fix the problem I was having. And yes, your solution of going serial is valid. The reason parallel matters is not in creating the tables per se, but all the scripts I have to do after creating the table. Creating tables was simple and quick script for me to practice; for me to understand this method, so I can apply the lessons to the other, more complex scripts that have to be run in parallel. And yes, I now have learned the concurrent writing limitation of sqlite is a problem. I am actually as a result, tonight, switching to PostegreSQL for this reason. This way, I can solve the problem for the aforementioned future scripts that I do need to run in parallel. Thank you for your contribution.

Member 15071189 12-Feb-21 12:14pm View

Richard is correct. So this code worked:"python "CreateDataTablePythonScriptv2.py" USDJPY"

Member 15071189 12-Feb-21 12:11pm View

That is the cause. Thank you! Your idea fixed it.

Member 15071189 12-Feb-21 9:30am View

Yes, something is happening with the concat when in parallel. Its weird because it works correctly if I don't concat the strings; if I just create a Table name with the arg only, it works in parallel accessing the same database.

Comments by Member 15071189 (Top 4 by date)