diff options
| author | Yorhel <git@yorhel.nl> | 2009-12-05 16:28:43 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-12-05 17:20:34 +0100 |
| commit | 1e541e2643929b792089671a60bd40a7bdfee541 (patch) | |
| tree | 75770ab753e413eae38b6ad7536795a10d014b14 /lib/Multi | |
| parent | c67155961f1903a5e7c6c99b84cae08b7046a1a3 (diff) | |
SQL: Don't allow argument of update_vncache() to be 0
To batch update, simply do a
SELECT update_vncache(id) FROM vn;
The function is now more readable as well.
Diffstat (limited to 'lib/Multi')
| -rw-r--r-- | lib/Multi/Maintenance.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Multi/Maintenance.pm b/lib/Multi/Maintenance.pm index b952c490..1434fa73 100644 --- a/lib/Multi/Maintenance.pm +++ b/lib/Multi/Maintenance.pm @@ -101,7 +101,7 @@ sub log_stats { # num, res, action, time sub vncache { # this takes about 50s to complete. We really need to search for an alternative # method of keeping the c_* columns in the vn table up-to-date. - $_[KERNEL]->post(pg => do => 'SELECT update_vncache(0)', undef, 'log_stats', 'vncache'); + $_[KERNEL]->post(pg => do => 'SELECT update_vncache(id) FROM vn', undef, 'log_stats', 'vncache'); } |