I use solr for searching and facets and love it.. The performance is
awesome.
However I am about to add tagging to my application and I'm having a hard
time deciding if I should just database my tags for now until a better solr
solution is worked out... Does anyone know what technology some of the
larger sites use for tagging? Database (MySQL, SQL Server) with denormalized
cache tables everywhere, something similar to solr/lucene, or something
else?
Thanks,
Mike
----- Original Message -----
From: "Mekin Maheshwari" <[EMAIL PROTECTED]>
To: <solr-user@lucene.apache.org>
Sent: Thursday, February 22, 2007 7:39 AM
Subject: Re: Tagging
For a more general solution, I'm thinking a separate lucene index
might be ideal.
-Yonik
I dont know if this will work for others, below is what we do. Also, if
there are things I can improve, do let me know.
All tag inserts go to a small DB table.
And I reindex the docs that these tags belong to in a backup index that I
keep, and swap the new Index in from time to time. I dont do this on the
production index, as optimizing the index takes a long time.
A hack that I need to do is when looking up for tags, I also look in this
small table. For me exact matches suffice, hence a db table works, may not
work for others. I understand that searches on this tag dont work, till it
gets into the index.
The solution can obviously be made much smarter.
Basically use a queue, from which the indexUpdater can pick up documents
to
reindex & update them when search volumes are low.
I am sure a small lucene index can be used as the queue, and while
searching
both the indices are looked at.
Btw, we are still using lucene for our search, hope to move to solr soon.
-mekin
