On 15 Feb 2020, at 8:12pm, J Decker <d3c...@gmail.com> wrote: > memcmp is harder than strcmp? > and with blob I suppose you don't have 'if UTF8 or UTF16 do > different things' so should compare slightly faster?
It's not cut-and-dried, but you can take things into consideration. Once data is in a database it usually just sits there. You're mostly interested in input and output. Think of the number of times you're going to do conversions, and what formats you're converting from and to. How much processing is involved in each conversion. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users