Python - 1 : C# - 0
I tend to get chided when I mention to my developer friends that I prefer to work in Python if I can. Python is a general purpose language that helps me get my personal projects done faster with less coding. I'll follow up with a post on things I like and dislike about Python on another post later.
At work we work exclusively on Microsoft SharePoint Server with C#. One of our developers was trying to write a routine that would write 50MB of data from MS SQL Server to Excel. Using C# our guy couldn't get the run time to be under 30 minutes. To me, 50MB isn't a lot of data. There's no reason that it should take that long.
A quick Google search to find a Python module to connect to MS SQL Server turned up PyODBC. With the excellent pyExcelerator library installed I was ready for battle. Fifteen minutes† and thirty lines of code later (including timing code) I had a quick prototype in Python working that runs in 49 seconds. Down from 30 minutes, that's a 3573% speed increase. Needless to say my co-workers were all dumbfounded that Python would be so efficient over Microsoft's flagship language. I admit that I was pleasantly surprised as well but mostly just so that I wouldn't have to eat crow when it didn't work ;)
†The only reason it took fifteen minutes was because I had to familiarize myself with PyODBC and how to execute stored procedures with it. After fetching the data it was only two simple for loops to get the data written.
![[link:home]](http://thebuckpasser.com/images/home.png)
![[link:about me]](http://thebuckpasser.com/images/aboutme.png)
![[link:rankings]](http://thebuckpasser.com/images/rankings.png)



http://www.softugg.com/ugg-mayfaire-boots-c-27.htm... ugg mayfaire boots
http://www.softugg.com/ugg-knightsbridge-c-20.html... ugg knightsbridge boots
http://www.softugg.com/black-ugg-classic-crochet-b... CBlack UGG Classic Crochet Boots
http://www.softugg.com/sand-ugg-classic-mini-boots... Sand Ugg Classic Mini Boots
http://www.softugg.com/ugg-classic-argyle-knit-cha... UGG Classic Argyle Knit Charcoal
http://www.softugg.com/chestnut-ugg-classic-tall-b... chestnut Ugg Boots
http://www.softugg.com/chestnut-ugg-handbags-p-194... Chestnut UGG Handbags
http://www.softugg.com/ugg-bailey-button-c-15.html...
http://www.softugg.com/ugg-classic-cardy-black-p-1...
http://www.softugg.com/black-ugg-classic-short-boo...
http://www.softugg.com/chocolate-ugg-classic-tall-...
http://www.softugg.com/ugg-classic-argyle-knit-cre...
http://www.softugg.com/chocolate-ugg-classic-mini-...
http://www.softugg.com/black-ugg-mens-layback-p-28...
http://www.softugg.com/chestnut-ugg-nightfall-boot...
http://www.softugg.com/ugg-5822-stripe-cable-knit-...
http://www.softugg.com/black-ugg-ultra-short-boots...
http://www.softugg.com/black-ugg-ultra-tall-boots-...
http://www.softugg.com/white-ugg-classic-crochet-b...
http://www.softugg.com/pink-ugg-handbags-p-198.htm...
http://www.softugg.com/black-ugg-knightsbridge-boo...
http://www.softugg.com/ugg-womens-mayfaire-chestnu...
http://www.timberlandfans.com/mens-6-inch-boots-c-1.html Men's 6 Inch Boots
http://www.timberlandfans.com/kids-timberlands-boots-c-9.html Kids Timberlands Boots
http://www.timberlandfans.com/mens-chukka-boots-c-2.html Men's Chukka Boots
http://www.timberlandfans.com/mens-rolltop-boots-c-4.html Men's Roll-Top Boots
http://www.timberlandfans.com/timberland-classic-boots-c-5.html Timberland Classic Boots
http://www.timberlandfans.com/womens-6-inch-boots-c-6.html Women's 6 Inch Boots
http://www.timberlandfans.com/womens-high-top-boots-c-7.html Women's High Top Boots
http://www.timberlandfans.com/womens-rolltop-boots-c-8.html Womens Roll-Top Boots
http://www.timberlandfans.com/timberland-kids-boots-model193024-p-47.html
http://www.timberlandfans.com/timberland-chukka-boots-mens-model027632-p-118.html
http://www.timberlandfans.com/mens-custom-timberland-boots-model193057-p-26.html
http://www.timberlandfans.com/timberland-mens-rolltop-boots-model193264-p-34.html
http://www.timberlandfans.com/womens-rolltop-timberland-boots-model193228-p-143.html
http://www.timberlandfans.com/timberland-mens-classic-3eye-lug-pullup-p-75.html
http://www.timberlandfans.com/timberland-womens-high-top-boots-pink-p-139.html
http://www.uggkissyou.com/uggs-mayfaire-boots-c-30...
http://www.uggkissyou.com/uggs-ultra-short-boots-c...
http://www.uggkissyou.com/uggs-ultra-tall-boots-c-...
http://www.uggkissyou.com/uggs-knightsbridge-c-23....
http://www.uggkissyou.com/uggs-classic-crochet-c-6...
http://www.uggkissyou.com/uggs-stripe-cable-knit-c...
http://www.uggkissyou.com/uggs-nightfall-boots-c-7...
http://www.bayuggboots.com/ugg-classic-short-c-4.h...
http://www.bayuggboots.com/ugg-nightfall-boots-c-1...
http://www.bayuggboots.com/ugg-knightsbridge-c-20....
http://www.bayuggboots.com/ugg-classic-crochet-c-9...
http://www.bayuggboots.com/ugg-amelie-sandals-c-11...
http://www.bayuggboots.com/ugg-handbags-c-6.html
http://www.bayuggboots.com/ugg-classic-tall-c-8
http://www.sneakerslike.com/adidas-shoes-c-1.html
http://www.sneakerslike.com/adidas-shoes-mens-adid...
http://www.sneakerslike.com/adidas-shoes-womens-ad...