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

[Evangelos Foutras]

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?