For the previous post I talked about recreating my random customer SQLite database. I had rewritten this program in Julia and was happy with the speed improvements [see this post]. So because of my feeling of constantly fighting with Julia to work with SQLite, a short time ago I started work on getting it to run in Python 3. Which also included recently adding a random amount field.
Here is the last few seconds output, of my Python 3 program creating 1,000,000 records. As you can see it took about 30 minutes. So a substantial 45 minutes faster than the Python 2 program, and only about 10 minutes longer than the Julia program. To have a program that doesn’t break at every point release…I can live with slightly slower speeds!
998000 Written 2000 remaining
999000 Written 1000 remaining
1000000 Written 0 remaining
Finished!
real 30m16.161s
user 24m42.720s
sys 5m31.454s
(base) [bill@bill-ms7b79 CreateCustomer]$