Converting Stored Procedures to Python: Issues
Posted: Tue Apr 23, 2013 6:05 pm
We are moving from an Informix DB to Vertica and have to convert ALL our Informix stored procedures to some kind of combination of SQL and Python. However, that is not working out very well and I am at a loss on how to circumvent these issues. There is no problem converting the stored procedure to a python script BUT the time to insert/update tables through a loop is unacceptable in the python scripts. It is taking hours for a simple insert/update to complete for 10000 rows. The stored procedures are based on FOREACH loops and converting them to Python makes them virtually impossible to run time wise. I would appreciate any help and/or possible alternatives with this issue!
Thanks,
CVezza
Thanks,
CVezza