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?

Cecil Westerhof
sqlite-users mailing list

Reply via email to