Uhm..ok good. But what's "normal"? I know how to cache objects on Memcached but what I want is to integrate this kind of thing into Thinking Sphinx. Is it possible? Otherwise you mean to cache objects *after* the call on Sphinx...am I right?
On Wed, Aug 3, 2011 at 11:12 AM, Pat Allan <[email protected]> wrote: > Hi Nicola > > Using memcached just like normal should be fine with Thinking Sphinx - I > know others have used it in the past. I'd guess other caching tools are fine > as well. > > Cheers > > -- > Pat > > On 03/08/2011, at 6:56 PM, Nicola Junior Vitto wrote: > > > Yes I watt to retrieve the entire object. The problem is that I h ave an > action with 6 calls to Sphinx that since the hit also on db is causing a > huge overhead of 2/3 seconds response time...that's not acceptable. > > > > Is there a way to integrate some sort of caching (Memcached) to retrieve > the entire objects instead of hitting the database? > > > > Thank you very much! > > > > Sent from a touch-interface mobile device. > > > > Il giorno 03/ago/2011, alle ore 03:43, Pat Allan < > [email protected]> ha scritto: > > > >> Normal Thinking Sphinx searches will always make a query to the database > as well - Sphinx cannot store all the information about a model instance, > let alone associated model information, hence why the database request is > required. > >> > >> However, you can limit the request to just the instance ids instead by > using Item.search_for_ids instead of Item.search - but given you want > content and sku objects, I'm guessing that's not the behaviour that's > desired. > >> > >> Cheers > >> > >> -- > >> Pat > >> > >> On 03/08/2011, at 1:48 AM, zetarun wrote: > >> > >>> Hi all, > >>> I'm using eager loading in thinking sphinx searches in the same way I > >>> use it for active record searches. The problem is that I don't want to > >>> hit the database when I run searches on Sphinx but this is not the > >>> behaviour of the ":include" attribute in my TS calls.. > >>> > >>> For instance, this search query: > >>> Item.search :match_mode => :fullscan, :with => {:featured => > >>> true}, :per_page => 200, :include => [:contents, :skus] > >>> > >>> Hit the database to retrieve the objects contents and skus while I > >>> expected to have all the object I requested by Sphinx...note that all > >>> the objects in the :include are indexed in the "define_index" of Item > >>> model. > >>> > >>> What am I doing wrong? > >>> > >>> Thank you very much! > >>> > >>> -- > >>> 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. > >>> > >> > >> -- > >> 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. > >> > > > > -- > > 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. > > > > -- > 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. > > -- 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.
