<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix"><font size="-1"><font face="DejaVu Sans
Mono">Hi <font size="-1">Ken,<br>
<br>
<font size="-1">Sorry I may not have got you. So isn't there
a worka<font size="-1">round <font size="-1">for the <br>
<font size="-1">issue with *<b>existing* </b></font>records<font
size="-1">? I think I need not change DB since<br>
<font size="-1">I've already compiled M<font
size="-1">ySQL with 'sphinxse'</font></font>. It
is the s<font size="-1">phinx<br>
<font size="-1">configuration I'm concerned with.<br>
<br>
<font size="-1">Thanks,</font></font></font></font></font></font></font></font></font></font><br>
<br>
<br>
On Monday 04 February 2013 10:33 PM, <a class="moz-txt-link-abbreviated" href="mailto:ktm@rice.edu">ktm@rice.edu</a> wrote:<br>
</div>
<blockquote cite="mid:20130204170306.GD12811@aart.rice.edu"
type="cite">
<pre wrap="">On Mon, Feb 04, 2013 at 10:28:23PM +0530, Subin wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hello all,
Thanks to Arkadiusz Miskiewicz for sharing his knowledge here:
<a class="moz-txt-link-freetext" href="http://lists.fsck.com/pipermail/rt-users/2011-August/072464.html">http://lists.fsck.com/pipermail/rt-users/2011-August/072464.html</a>
My question is based exactly on this config which I find is good.
"As per my understanding" the 'delta' index makes newly created
rows/records available by using 'SphinxCounters' table. That is
the delta index which will be run every 15 minutes will check if
any row which has 'id' greater than the 'id' stored previously
in 'max_doc_id' column of 'SphinxCounters' table. If greater
then it will read the source and then add the new record to the
'delta' index.
If an edit/update happens to an *"existing"* ticket/document/row in
the source database, how will this change get updated into indexes
quickly? So according to this config, we will need to wait until
the next time the 'main' is reindexed again, right? If true how
can we have a workaround for this problem?
Please excuse and let me know if I made any wrong assumptions
here.
Thanks,
</pre>
</blockquote>
<pre wrap="">
Hi Subin,
That is how the Sphinx full-text indexing works. You would need to
change to a different DB backend with integrated support for fulltext
indexing. PostgreSQL and Oracle will both work. Eventually, when MySQL
supports full-text indexing with InnoDB natively, RT can be made to
use it as well.
Regards,
Ken
</pre>
</blockquote>
<font size="-1"><font face="DejaVu Sans Mono"><font size="-1"><font
size="-1"><font size="-1"><font size="-1"><font size="-1"><font
size="-1"><font size="-1"><font size="-1"></font><br>
</font></font></font></font></font></font></font></font></font>
</body>
</html>