Mercurial > gemma
comparison pkg/controllers/importqueue.go @ 2673:df2a31e8f257 import-overview-rework
Re-added LIMIT 1 hint to prev/next SELECTs.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 14 Mar 2019 17:42:15 +0100 |
parents | b997e1fd1d3d |
children | fe93c48f76c9 |
comparison
equal
deleted
inserted
replaced
2672:b997e1fd1d3d | 2673:df2a31e8f257 |
---|---|
222 if !a.hasCond { | 222 if !a.hasCond { |
223 a.stmt.WriteString(" TRUE ") | 223 a.stmt.WriteString(" TRUE ") |
224 } | 224 } |
225 | 225 |
226 l.stmt.WriteString(" ORDER BY enqueued DESC ") | 226 l.stmt.WriteString(" ORDER BY enqueued DESC ") |
227 a.stmt.WriteString(" ORDER BY enqueued ") | 227 a.stmt.WriteString(" ORDER BY enqueued LIMIT 1") |
228 b.stmt.WriteString(" ORDER BY enqueued ") | 228 b.stmt.WriteString(" ORDER BY enqueued LIMIT 1") |
229 | 229 |
230 if noBefore { | 230 if noBefore { |
231 b = nil | 231 b = nil |
232 } | 232 } |
233 if noAfter { | 233 if noAfter { |