9 Apr
2009
9 Apr
'09
5:44 p.m.
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?