Comments for Musings of an Anonymous Geek http://www.protocolostomy.com Made with only the finest 1's and 0's Wed, 10 Mar 2010 20:02:17 +0000 http://wordpress.org/?v=2.9.2 hourly 1 Comment on Clone a table in MySQL without killing your server by Bill http://www.protocolostomy.com/2008/10/09/clone-a-table-in-mysql-without-killing-your-server/comment-page-1/#comment-36559 Bill Wed, 10 Mar 2010 20:02:17 +0000 http://www.protocolostomy.com/?p=365#comment-36559 I recently looked this article back up because I am a new company and needed this script again. Great script with one exception. The limit command starts to deteriorate in performance when you have larger tables (at least with MyISAM which we were using). I had a database with 40M rows and after a million or two performance came to a crawl. I don't have access to the script anymore, but at the time I rewrote it to use the Primary key column instead. You do run into dead spots if they table has had deletes but for the most part it is quick. Be sure to order on the primary key if you use that method. I recently looked this article back up because I am a new company and needed this script again. Great script with one exception. The limit command starts to deteriorate in performance when you have larger tables (at least with MyISAM which we were using). I had a database with 40M rows and after a million or two performance came to a crawl. I don’t have access to the script anymore, but at the time I rewrote it to use the Primary key column instead. You do run into dead spots if they table has had deletes but for the most part it is quick. Be sure to order on the primary key if you use that method.

]]> Comment on Generating Reports with Charts Using Python: ReportLab by A Simple Step-by-Step Reportlab Tutorial « The Mouse Vs. The Python http://www.protocolostomy.com/2008/10/22/generating-reports-with-charts-using-python-reportlab/comment-page-1/#comment-36484 A Simple Step-by-Step Reportlab Tutorial « The Mouse Vs. The Python Tue, 09 Mar 2010 01:03:39 +0000 http://www.protocolostomy.com/?p=373#comment-36484 [...] Generating Reports with Charts [...] [...] Generating Reports with Charts [...]

]]> Comment on Generating Reports with Charts Using Python: ReportLab by Onalie Sotak http://www.protocolostomy.com/2008/10/22/generating-reports-with-charts-using-python-reportlab/comment-page-1/#comment-36277 Onalie Sotak Fri, 05 Mar 2010 20:08:17 +0000 http://www.protocolostomy.com/?p=373#comment-36277 This was really helpful - thank you! This was really helpful – thank you!

]]> Comment on Show Me Your Python SysAdmin One-Liners! by Ted King http://www.protocolostomy.com/2008/07/16/show-me-your-python-sysadmin-one-liners/comment-page-1/#comment-36260 Ted King Fri, 05 Mar 2010 12:26:13 +0000 http://www.protocolostomy.com/?p=334#comment-36260 If Perl's "ucfirst" is not enough try this : cat raw.txt | python -c "import string,sys;[[sys.stdout.writelines(LT)] for LT in [[string.capwords(LS)+'\n'] for LS in sys.stdin.readlines()]]" > Proper.txt Keywords : capwords(), initcaps(), proper() SUSE 10, Python 2.4 If Perl’s “ucfirst” is not enough try this :
cat raw.txt | python -c “import string,sys;[[sys.stdout.writelines(LT)] for LT in [[string.capwords(LS)+'\n'] for LS in sys.stdin.readlines()]]” > Proper.txt

Keywords : capwords(), initcaps(), proper()
SUSE 10, Python 2.4

]]> Comment on If You Code, You Should Write by php|architect Podcast: Microphones in Bloom | php|architect http://www.protocolostomy.com/2009/09/09/if-you-code-you-should-write/comment-page-1/#comment-36183 php|architect Podcast: Microphones in Bloom | php|architect Thu, 04 Mar 2010 12:04:02 +0000 http://www.protocolostomy.com/?p=624#comment-36183 [...] If You Code, You Should Write [...] [...] If You Code, You Should Write [...]

]]>