Find Jobs
Hire Freelancers

Joomla Plugin. Lots of MySql Queries. Need to rewrite to cache ahead

$30-250 USD

Cancelled
Posted almost 12 years ago

$30-250 USD

Paid on delivery
Hello All, I currently have a website ([login to view URL]) which has a photobattle component on it. You can see it on the first page that you go to when you go to the website. Basically two photos are loaded, and the user can vote for which one they like best. Problem is, each time the page loads, a mysql query hits that queries the database and randomly finds two photos based on the selected category defined in the joomla session for the user or guest. This makes the site very database intensive, and slow, and prevents me from being able to host it on a lower shared hosting plan. I also have modules (leader boards for instance) and component views (the winners pages) that are also very mysql query intensive. I need to cut down on the number of mysql queries so that I can host on a shared hosting plan. I need someone who knows the Joomla architecture, and knows how to rewrite components to utilize caching techniques to reduce the number of queries. Please visit my site, and let me know in a PM how you think it could be rewritten to be faster, with less queries to the database. The # of photos on each page changes seldomly... The number of wins/losses for each photo is actually stored in real time in the database so those database writes will still have to exist. I just think that querying for a new random photo every single time the page loads is what is killing my performance. In your bid, or PM to me, please explain in detail what you see as being possible. If you don't, i wont even respond to your PM as there's too much spam on this system now. Also... I'm open to a complete rewrite of the component in it's entirety to harness HTML5 as well if that's possible and would make it faster. Thanks and I look forward to hearing your ideas.
Project ID: 2360442

About the project

7 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $214 USD for this job
User Avatar
We are interested in your projects. Website, mobile apps development are our range projects. Please check PMB for our profile & portfolio. Thanks a lot! ArrowHiTech Jsc!
$250 USD in 8 days
4.7 (327 reviews)
8.6
8.6
User Avatar
Hi Please check PMB Thanks Sandy
$200 USD in 4 days
5.0 (10 reviews)
4.5
4.5
User Avatar
Hi, I am a web development professional having more than 5 years of experience on various technologies with many big corporate. I can give the best result in shortest time. I am sure you will be satisfied with my work. Thanks and have a nice day.
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, Greetings! We are Reform Consulting with 5 year of experience under our belt. We are really interested to work on your project. Please see PM. Thank you. Regards, RCPL.
$200 USD in 7 days
0.0 (3 reviews)
3.2
3.2
User Avatar
Hello! I'm confident that me, and my staff could complete this work for you. If you have any questions for us, please let us know. We can speak via skype if we need to during the duration of the project.
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
North Grafton, United States
5.0
12
Payment method verified
Member since Oct 27, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.