Re: [sqlite] Lowering totalUsed

2018-07-12 Thread Keith Medcalf
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 numbers

Re: [sqlite] Lowering totalUsed

2018-07-12 Thread Simon Slavin
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

Re: [sqlite] Lowering totalUsed

2018-07-12 Thread Cecil Westerhof
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: >

[sqlite] Lowering totalUsed

2018-07-12 Thread 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: UPDATE tips SET totalUsed = totalUsed - (SELECT