Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.
  • Root
  • » Django
  • » Real time search using Django Sphinx or haystack Xapian [RSS Feed]

#1 June 20, 2010 02:26:12

z.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

Real time search using Django Sphinx or haystack Xapian


" 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-freshother 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 athttp://groups.google.com/group/django-users?hl=en.

Offline

  • Root
  • » Django
  • » Real time search using Django Sphinx or haystack Xapian [RSS Feed]

Board footer

Moderator control

Enjoy the 14th of December
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support