|Anonymous | Login | Signup for a new account||2020-01-20 05:48 GMT|
|Main | My View | View Issues | Change Log | Roadmap|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001043||SiT!||incidents||public||2010-01-15 19:36||2012-01-24 13:11|
|Target Version||Fixed in Version|
|Summary||0001043: Consider changing how search works|
|Description||We should consider changing how the search functionality in SiT works, currently we use full text searches which are fine in relatively small systems though in larger systems can cause quite a performance overhead on the database server, are limited to MyISAM tables and requirements for a lock can mean that other users are unable to use SiT whilst the search takes place.|
We should investigate the use of something like Lucene or Sphinx which are separate search engines which should remove/reduce the problems we experience with full text indexes, I've not used these previous so may not be suitable due to platforms or how they work though this should be investigated to prevent performance issues.
A 'hack' would be to use a slave server for searches which would prevent other users from being impacted this could be done quite easily in SiT though would require additional servers and MySQL skills.
|Tags||No tags attached.|
|Probably worth mentioning on the dev mailing list or the forum and then making a bug here when something is decided really. Full text searching can have it's issues, but it's also extremely useful. I think currently the good outweighs the bad, but yeah I agree it's worth investigating alternatives.|
I'll send something to the dev list shortly, I'm not proposing that we loose the functionality in SiT just change how we achieve it.
I know we're experiencing quite a few 'hangs' of SiT internally when someone does a full text search happens a couple of times a week hence why I logged it
I think we should have a "tickbox" in the search page for someone who specifically wants to use full text search (thus disabled by default). When you want to do full text search you just tick the box and then you go.
Our system is not very big (yet) so the effect is not so evident, but the full text search is very useful to have.
|I don't see a great demand for this. Search seems to work for me... It could be a lot better of course but I'm not sure some heavyweight third party software is the best solution. Unless we propose a plugin or something.|
|2010-01-15 19:36||paulh||New Issue|
|2010-01-15 19:54||ivan||Note Added: 0002287|
|2010-01-15 20:04||paulh||Note Added: 0002288|
|2010-01-19 14:06||nicdev||Note Added: 0002291|
|2012-01-24 13:11||ivan||Note Added: 0004424|
|2012-01-24 13:11||ivan||Status||new => acknowledged|
|Copyright © 2000 - 2020 MantisBT Team|