>
> You're doing this on 68 million rows. While it probably shouldn't
> give an error in this way, I can imagine various things that might
> cause it.
>
> To help with debugging, and also as a suggested fix until the problem
> can be investigated, could you pre-calculate your 'strftime' value,
> and use that in the command instead ? It would help to see whether
> the calculation of this is the thing causing the error. You can use
> SQLite to do the calculation
>
> sqlite> SELECT strftime('%s', 'now', '-7 days');
> 1251679819
>
> if you like. Then take whatever value you get and plug it into the
> DELETE command:
>
Good idea. Tried that, though, and it didn't help - the process still grew
and grew in memory.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
