Hi Pat, Thanks, will try it out.
Johann On Wednesday, November 14, 2012 7:12:53 PM UTC+8, Pat Allan wrote: > > Hi Johann > > Answers in context below… > > On 13/11/2012, at 7:50 PM, Johann Tagle wrote: > > > Hi. First of all thank you for creating and sharing this project. I > have two questions: > > > > 1. I noticed in the generated configuration file under "sql_query" the > id for the index is computed as CAST(2 AS SIGNED) + 1. Any reason for this > vs just using the id as is? Is there any way to have TS to just do the > latter? The reason for asking is I also use the MySQL SphinxSE plugin for > data-mining, etc and it looks ugly to always have to include a "(( > sphinx_search_table.id - 1) / 2)" when joining the search results table > with the table of the model and/or other tables. > > Thinking Sphinx can't use the primary key values directly, because Sphinx > requires unique document ids across *all* indices, not just each one. > Hence, you'd end up with collisions. > > However, if you look at the generated configuration file, you'll also spot > an attribute for the primary key value, which may make things easier for > you. > > > 2. We use acts_as_taggable_on and I've seen many examples on how to > index tags in relation to the model. However, we have a requirement where > we want to index the Tag/Tagging models themselves so that we can use that > index for autocomplete. I know how to use TS for autocomplete, but I'm > quite at a loss how to index the Tag/Tagging models on their own. Can this > be done? > > Hmm… I'm not entirely sure of the best way to manage this, but you'll > probably need to add something like the following to a file that'll be > automatically loaded (to ensure it's part of your app): > > Tag.define_index do > # … > end > > Tagging.define_index do > # … > end > > Class methods are class methods, after all. > > Cheers > > -- > Pat > > > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To view this discussion on the web visit https://groups.google.com/d/msg/thinking-sphinx/-/6ClcFZ8XJfYJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
