Less than 1 week –
Less than 10 hrs/week –
I have a website using sphinx as search engine and i have some problems with cpu usage. Even there are 10-30 users sphinx proccess shows %300 cpu load and typing "top" shows %90 of total cpu load.
The index table contains between 200.000-300.000 results (products changes daily) and the index is usually around 10MB.
I have this machine: http://www.online.net/en/dedicated-server/dedibox-md
I want sphinx to be optimized for best performance.