On Sun, Jun 17, 2012 at 4:32 PM, Bill House <wch-tech(at)house-grp(dot)net> wrote:
> I have a written a script which does what I want it to do on a table
> with 999 records.
>
> I was wondering if there is anything I need to consider if I run this
> script on a table with 1.1 million records?
It looks fine for me. The only note is that, I may be wrong, but
"UPDATE %s SET del = False" updates the records having del already
false too, taking more time and creating unnecessary bloat. Adding
"WHERE del" may help keeping the bloat to the minimum.
-- Daniele