I have a client with a cool project, we've made good progress on the development but now have ran into issues with using Views and having large queries. We are on VPS boxes, a database server (4GB) and a web server (2GB) we have cronjobs happening on other (1GB) VPS boxes.

I tried implementing SOLR, but the Views required some dynamic data (i.e., Flag and VBO). I'm aware that using Views is not as optimized as EntityFieldQuery directly, but the client is fond of controlling business logic in the UI (Views UI).

I'm hoping to spend some time with an individual in regards to the stated problem. I hope to come with a reasonable flat rate option for time and services with challenges like this, maybe $1k/month for 3 months. Please contact directly - send resume, Drupal username, description of past related work (developer to developer speak), your location (U.S. or not) and preferred pricing.