Timeline for slow Python script pulling from an iSeries database
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:34 | history | edited | CommunityBot |
replaced http://gis.stackexchange.com/ with https://gis.stackexchange.com/
|
|
| Oct 29, 2014 at 20:33 | comment | added | PolyGeo♦ | A 20x improvement sounds great! | |
| Oct 29, 2014 at 20:13 | comment | added | Winston | Did some more work with the script and created the cursor outside of the loop and cut the processing time down to 3min and change. It seems that my script was creating a cursor for each record that was input.... that takes up a lot of time. | |
| Oct 29, 2014 at 15:33 | comment | added | Winston | I took your advice and added the time function to the script. It takes @ 0.03 seconds to import each record, but there are 59K records to populate and it still takes @ 60min to complete the script. Is there any to speed this up? Also, when I run this script to export to Access it takes @2min to run. | |
| Oct 28, 2014 at 23:10 | history | answered | PolyGeo♦ | CC BY-SA 3.0 |