Search seems more performant!

[danielrosehill]

I'm a big believer in the idea that sharing what works well after updates is just as important as filing bug reports.

My inventory is approaching 5K items.

I'm on Sqlite but have it as a rainy day project to migrate to postgres.

in any event, I just wanted to share that, unless I'm imagining things, the search and indexing performance, both seem much improved after upgrading.

There are still times when I wish the search logic was just a little bit fuzzier. And sometimes it takes a second push of the search button to update the results count.

But overall the search results are populating faster and i seem to be having less trouble in finding matches quickly.

Thank you for the update!

[tankerkiller125]

Most likely the indexes were missing in the v0.19.0 release, because SQLite doesn't support updating columns in-place (a very stupid limitation IMO) the table has to be recreated with a different name, the data from the original table moved to the new table, the original table dropped, and then the newly created table renamed.

Because of this whole convoluted process it's extremely easy to accidently forget about the indexes when creating migrations.