The build_query is not efficient. It uses the LIKE operator therefore it does not uses proper full text search. Full text search builds an index of keywords and can efficiently search them inside text. Whoosh, Solr, and other libraries to that. Haystack is a wrapper named after the equivalent Django module.
On Friday, 16 September 2016 10:05:29 UTC-5, Ron Chatterjee wrote: > > I never used heystack so its interesting. How the heystack has advantage > over this? > > query = SQLFORM.*build_query*(list_of_searchable_fields,search_text) > > > > > > On Thursday, September 15, 2016 at 6:51:25 PM UTC-4, Donald McClymont > wrote: >> >> Massimo has also posted this as a starting point >> https://github.com/mdipierro/web2py-haystack which may be a useful >> starting point- I haven't used with solr but did manage to extend to GAE >> Search without too much difficulty. >> >> Regards >> Donald >> >> On Wednesday, September 14, 2016 at 4:42:55 PM UTC+1, Massimo Di Pierro >> wrote: >>> >>> You can ask here. If we can help for free so that everybody benefit the >>> better. If instead you have private code and do not want to show, please >>> contact one of the companies doing web2py support listed from the web2py >>> page. >>> >>> On Wednesday, 14 September 2016 08:37:21 UTC-5, Morris Fourie wrote: >>>> >>>> I need assistance with Web2py and Solr UI. I am new and not at the >>>> right level yet but am willing to pay. I hope I am at the right forum and >>>> come anyone help >>>> Thanks >>>> Mo >>>> >>>> >>>> >>>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
