On 31/03/2009, at 12:43 PM, court3nay wrote: > On Mar 30, 5:06 pm, Pat Allan <[email protected]> wrote: >> The issue is definitely tied to delta indexes. Sphinx calculates it's >> ordinal attributes from strings on a per-index basis - so the core >> index is one set of values, the delta index another, and treated as >> if >> they're unrelated. > > That's so... weird. I have a few ideas.. > > - disable the delta index completely > - make the delta index clear out quicker > - create our own ordering algorithm that stores an integer > representation of that field, suitable for ordering, and index that? > What would that algo look like?
Hmm, that last one could work quite well, actually... use a normal integer attribute to do exactly the same as what Sphinx does. But update it accordingly, paying attention to both indexes. I wrote a basic script a while ago, to see if updating Sphinx's ordinal values was a possibility. I'd much prefer it become a bit smarter (it's not setup for multiple indexes just yet, and ideally could parse the Sphinx config file), and also be written in C so it's far faster, but it's a start. http://gist.github.com/88002 Not that I know enough C to really do it justice, but I want to avoid the Rails stack if at all possible. But between that, DataMapper support, excerpts support, etc - so much to do. Anyone want to pay me to implement a feature? ;) (No harm in asking, right?) -- Pat --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
