php / adodb – memory usage

i’ve got seemingly simple php script running every night on one of my servers… on the same machine i started to experience nightly oom-killer. i’ve found out that adodb’s Execute statement can do something completely else than you would expect from it – it loads whole result into memory rather than going row-by-row.

firefox speedup

from this site. and it seems to be working. Go to MenuTools -> Error Console Paste the following in the “Code:” text-box: Press Enter or click Evaluate. The database will thence be vacuumed immediately.