Re: Question about optimization

2008-07-24 Thread Jean-Paul Calderone
On Thu, 24 Jul 2008 17:19:41 -0400, Wei Hao <[EMAIL PROTECTED]> wrote: Hi: I'm pretty new to python and I have some optimization issues. I'll show you the piece of code which is causing it, with pseudo-code before it and comments. I'm accessing a gigantic table (like 15 million rows) in SQL. d

Question about optimization

2008-07-24 Thread Wei Hao
Hi: I'm pretty new to python and I have some optimization issues. I'll show you the piece of code which is causing it, with pseudo-code before it and comments. I'm accessing a gigantic table (like 15 million rows) in SQL. d is some dictionary, r is a precompiled regex string Big loop, so I searc