Firstly, I am new to RentACoder, so please bear with me as I familiarize myself with the process.
The project I have is, I think, simple enough. I have a small website that runs on Ruby on Rails, which I developed myself. A major element of the site is having users that signup and edit their own content (text and images). With the content users add, each gets a personalized page that renders their content in a specific way. I don't want this to sound more complicated than it actually is; basically it's just a rails app that's got a fair amount of DB interaction. The DB I use is MySQL, and the site runs on a Mongrel Cluster.
Now, I can program, but I do not consider myself a programmer, and I don't really have very much time to dedicate to figuring out this issue: On all pages that have DB interaction, the requests per second are horrid. In the range of 0-2 reqs/sec. If it would help you assess the problem any, most of the time is spent in the "rendering" phase, according to the logs.
I would like to fix this, if possible, to get the reqs/sec somewhere into the hundreds (or higher). I believe that is a reasonable enough thing to expect the Rails framework to be capable of. And there may very well be a very easy solution to this problem, I just don't know what it is.
I am not sure how difficult of a job this is, but I am looking to pay $500 to have the app examined and optimized for much greater performance. If it is an easy job and only takes you a couple of hours, good for you, that's easy cash. If you really are capable of making the app perform at super speeds and you work diligently and are able to explain how you fixed things, I'll be happy enough to double your reward.
If the work demands another price, I'm willing to consider other bids.