[aur-general] pkgconflict: a tool to find file conflicts when building packages

Evangelos Foutras foutrelis at gmail.com
Thu Apr 9 13:44:35 EDT 2009

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?

More information about the aur-general mailing list