Thanks James - comments inline On Apr 26, 9:24 pm, James Healy <[email protected]> wrote: > Hi Mike, > > esp wrote: > > 1) Is there any way to add static data into a model. For example if > > a > > table with a row that has a name field that is "Loch Ness" is there a > > way > > that I can add static text to this so it will return results for the > > keyword "lake". > > You can pass raw SQL fragments to TS in your define_index block. > Assuming you're using mysql: > > indexes "IF(`name` = 'Loch Ness', 'lake','')", :as => :landmark > Not sure I follow the synax - I'm using PostgreSQL.
> > 2) I attempted to use the delta mechanism but after added the delta > > column > > and the set propertly :delta => true into my define_index section of > > my > > model, indexing for the first time never completed. I Hvae one table > > with > > close to 7 million rows that takes maybe a couple of minutes to index > > but > > after adding the delta and trying to create a fresh index, i let it > > run for > > 3 hours and it never even got to the point in the console output that > > said > > it was processing. It just showed the initial "creating index...". > > Is there an index on your delta column? > Doh! Forgot to add an index. That's gotta be it. Thanks! > -- James Healy <jimmy-at-deefa-dot-com> Mon, 27 Apr 2009 11:20:24 +1000 > > signature.asc > < 1KViewDownload --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. 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 -~----------~----~----~----~------~----~------~--~---
