Hi Harold
Can you post the stack-trace of that facet error?
The date-of-bith issue is odd - it's nice to know it works as a field,
but that means you won't be able to filter by it. I've seen this issue
occasionally, but not reliably, and would be awesome to track it down.
What happens if you switch it back to being an attribute, run ts:in,
and then check the sql_query value for that index in config/
development.sphinx.conf - remove the parts of the WHERE clause that
handle id paging, and see how many records it returns...
Dan: I've started to look through your fork, and I've been refactoring
both your and my code. Haven't got it ready for release just yet though.
Cheers
--
Pat
On 16/02/2009, at 3:47 AM, Harold A. Giménez Ch. wrote:
> Hi Dan. Thanks for your response.
>
> I did see the facet support. However, it is only working for me when
> the facet is on the model being indexed, not on one of its
> associations. If I try adding :facet => true to one of the
> attributes that are associations, it indexes without issues, but
> when calling Model.facets('something') I get an exception along the
> lines of:
>
> NoMethodError: undefined method `facet_name' for #<Class:
> 0x7f6a4d321a68>
>
>
> Regarding the question below about person.dob and why it would not
> index all of my records, turns out that I tried indexes person.dob
> (instead of has person.dob) and it did index the full set.
>
> Thanks again for the help,
>
> -Harold
>
>
> On Sun, Feb 15, 2009 at 11:39 AM, Dan Pickett
> <[email protected]> wrote:
> Hey Harold,
>
> The current version of Thinking Sphinx has facet support (add :facet
> => true to your attribute ). There's some additional functionality
> in my fork for class based facets, but it definitely could use some
> more love from contributors -
>
> http://github.com/dpickett/thinking-sphinx/tree/master
>
> I'm hoping to continue to work on it, but I haven't had a lot of
> free cycles.
>
> Regards,
> Dan
>
>
> On Sat, Feb 14, 2009 at 10:44 PM, Harold A. Gimenez <[email protected]
> > wrote:
> Hi,
>
> I started looking at sphinx today, with the intent to port an
> application's search engine from solr to sphinx. The solr
> implementation is solid, but doesn't meet my business needs - we
> have to bulk load the database and reindex new data more often than
> indexing solr takes! It is a huge bottleneck in our ops. I have a
> few comments which I'd like to share, as well as a couple of
> questions I hope I can get some guidance with.
>
> Sphinx (and TS) installation was a breeze. First step for me was to
> try out the indexing speed. I added a few fields and attributes to a
> Patient model and kicked off indexing. I was discouraged by how long
> it took. Turns out that the (fake) data I was indexing came from
> fixtures. Switching to a production-like database, with sequential
> primary keys, indexed 500K+ records in less than a minute. Wow!
>
> Now I have a problem. I've added a DOB attribute (has
> person.dob, :as => :date_of_birth). Now, when I run the index, it is
> only picking up 45885 docs (I'm expecting over 500K+). The dob
> field is of type timestamp. As a trial, I switched person.dob to
> person.created_at, and all of the 500K+ documents do get generated.
> Any thoughts on why this is happening?
>
> The next challenge is facet support, specifically on associations.
> Is there a fork somewhere where this has been implemented? Any
> pointers would be appreciated.
>
> Thanks,
> -H
>
>
>
>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
