diff options
| author | jakefeasel <jfeasel@gmail.com> | 2013-08-13 17:49:16 +0000 |
|---|---|---|
| committer | jakefeasel <jfeasel@gmail.com> | 2013-08-13 17:49:16 +0000 |
| commit | b7e280c5ba64fefc6e3bbf224e3282a6f80012da (patch) | |
| tree | 71b881785e6b2f813532b4adc488f31da14c2bae | |
| parent | 1b17e196f2993726e9f031b161844a9213b3a873 (diff) | |
| download | sqlfiddle-b7e280c5ba64fefc6e3bbf224e3282a6f80012da.zip sqlfiddle-b7e280c5ba64fefc6e3bbf224e3282a6f80012da.tar.gz sqlfiddle-b7e280c5ba64fefc6e3bbf224e3282a6f80012da.tar.bz2 | |
Adjusting the task query to prevent it from getting too large and busting my memory cap
| -rw-r--r-- | src/main/webapp/controllers/Tasks.cfc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/webapp/controllers/Tasks.cfc b/src/main/webapp/controllers/Tasks.cfc index c7a470f..4d40da9 100644 --- a/src/main/webapp/controllers/Tasks.cfc +++ b/src/main/webapp/controllers/Tasks.cfc @@ -3,7 +3,7 @@ <cffunction name="cleanup"> <cfscript> - var stale_schemas = model("Schema_Def").findAll(where="last_used < '#DateAdd('n', -30, Now())#' AND current_host_id IS NOT NULL", returnAs="objects", order="last_used"); + var stale_schemas = model("Schema_Def").findAll(where="last_used < '#DateAdd('n', -30, Now())#' AND current_host_id IS NOT NULL", returnAs="objects", order="last_used", maxRows="100", select="db_type_id,short_code,current_host_id,id"); var i = 0; for (i = 1; i<= ArrayLen(stale_schemas); i++) { |