You could filter them from the array with #compact*, I think, but ideally, you
would want to re-index. That's the problem with any search technique that
doesn't hit the live data directly. Yes, solr is much faster and can do way
more tricks, but it's not "live". How long does your index process take? Could
it be done after a delete without holding up the whole system for a ridiculous
duration?
Walter
*Actually, compact alone won't do it, because your results are not in an array
yet. You could cast the results to an array, or you could pass the current
"live" IDs into the search query. No idea how to do that in solr, but
hypothetically, it would be something like this (MySQL) query:
SELECT * FROM tickets AS t1 WHERE [your search here] AND t1.id
IN(SELECT id FROM tickets WHERE 1);
On Mar 19, 2014, at 5:52 AM, lavanya ramamoorthy wrote:
> i have a model Ticket which has 4 records.. I deleted first 2 records in the
> database..
>
> search = Sunspot.new_search(Ticket) do
> paginate(:page => 1, :per_page => 2)
> end
>
> list = search.execute
>
> list.results
>
> list.results returns [ ] for page 1 and the remaining 2 records for page 2.
>
> Ideally it should have been 1 page with 2 records. is it possible to avoid
> the records that not in database without re-indexing solr?
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rubyonrails-talk/8f8abd2e-641a-40fe-ad4e-6b6f0c72fdaf%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/50B8FD97-C7E6-4C02-A87F-DC0BA2BE2E38%40wdstudio.com.
For more options, visit https://groups.google.com/d/optout.
