" I'm storing a copy of the searchable text in a MyISAM table and using the MySQL search on it."
I need to search results to be immediately available as soon as they are updated in DB. This will require me to update the index in real time which is not very efficient. Haystack does provide real time index update. Has anyone used it. http://docs.haystacksearch.org/dev/searchindex_api.html#keeping-the-index-fresh other than that I have two other options: 1) Search db for data updated after the last search index update date and time and then show results from both Db and search engine. Risk is search index result could return stale data or I might get duplicates. 2) Use an appoach like yours - " copy of the searchable text in a MyISAM table and using the MySQL search on it." On Jun 19, 10:54 am, Nick Arnett <nick.arn...@gmail.com> wrote: > On Sat, Jun 19, 2010 at 9:21 AM, zweb <traderash...@gmail.com> wrote: > > > (Mysql text search will not work as I use INNODB. Solr is powerful but > > I heard it is very memory hungry and it is in Java. Whoosh is not yet > > as mature as others. So that leaves choice between Django Sphinx and > > Haystack Xapian.) > > I meant to mention that although I'm using InnoDB, I'm storing a copy of the > searchable text in a MyISAM table and using the MySQL search on it. That's > okay for now, but I'm looking for clustering, faceted search and other fancy > stuff. > > I've worked in search-related technology for a long time and I should know > that search performance always demands lots of memory... So I may bite the > bullet and use Solr, after all. I just wish there were a way to trade off > the memory for speed until I'm ready to deploy a real working version. > > Nick -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
