>To: SQLite mailing list
>Subject: [sqlite] Lowering totalUsed
>
>A few tables have a not completely apt named column totalUsed.
>
>It is used to see which records are more used as other records and
>give the
>less used records a bigger chance of being selected. When the nu
On 12 Jul 2018, at 8:30am, Cecil Westerhof wrote:
> I am not quit happy with this. Would it be better to split it in two
> queries and feed the result of the first to the second?
I would guess that it will run faster. How much faster depends on how many
rows there are in the table. Naturally
2018-07-12 9:30 GMT+02:00 Cecil Westerhof :
> A few tables have a not completely apt named column totalUsed.
>
> It is used to see which records are more used as other records and give
> the less used records a bigger chance of being selected. When the numbers
> become high I do something like:
>
A few tables have a not completely apt named column totalUsed.
It is used to see which records are more used as other records and give the
less used records a bigger chance of being selected. When the numbers
become high I do something like:
UPDATE tips
SET totalUsed = totalUsed - (SELECT MIN(tota
4 matches
Mail list logo