Chris Brannon wrote:
"select * from files where filename like '%/getmail'"
takes 5 seconds or so,
because it has to iterate through all the filenames in the table.

If sqlite were used for pkgfile, that second query would need to be quite
a bit faster than it is now.

-- Chris

Couldn't we simply introduce a new column, store the filename there and create an index on it?

Reply via email to