The number of records definitely has an impact on memory usage - Sphinx stores all attribute values (and this includes facet values) in memory. So, if you can remove the index for the 1500-record model, that should drop memory usage a bit.
Of course, the core parts of Sphinx require memory as well, and I'm not sure how much. It could be the number of records you're dealing with are so small in comparison it won't make much of a difference, but it's worth a shot. Cheers -- Pat On 02/08/2010, at 1:52 AM, anrake wrote: > Hi, I've been using TS on my shared host for a couple years now, but > now they have suspended my account (after a management change) because > Sphinx is taking too much cpu resources. Supposedly running TS on the > server takes its usage from around 3% to 30% according to support. Is > there any relation to the number of records and the CPU usage with > TS? I have one model that has about 200 records where I do faceting > on about 5 fields and one model with 1500 records that has faceting on > 3 fields. I could live w/o the 1500 one for awhile if it'll decrease > usage. > > I guess I need to switch to VPS or something for a more robust and > longterm solution but don't want to spend all the time on it right > now. > > Thanks > > -- > 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.
