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:
SET totalUsed = totalUsed - (SELECT MIN(totalUsed) FROM tips) + 1
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?
sqlite-users mailing list