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

Hello All,

I currently have a website ([url removed, login to view]) 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.


and I look forward to hearing your ideas.

Compétences : HTML, HTML5, Joomla, MySQL, PHP

en voir plus : caching mysql query joomla, joomla reduce queries, html5 no cache, how much time you need to make website, hits to your website, hits to my website, cache in html5, reduce queries joomla, database caching, joomla host, queries, pm to, mysql query, make still photos, joomla plugin, i need someone who makes a website, html5 less, how to pm someone, harness, database queries, single page html5, detail html5, mysql caching, component plugin, queries database

Concernant l'employeur :
( 12 commentaires ) North Grafton, United States

Nº du projet : #2360442

7 freelance font une offre moyenne de $214 pour ce travail


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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(327 Commentaires)

Hello Sir, Please read below to get information about our company and work done by us.. About company: Wtechsolutions Web Technology is an India based web design Company with great sk Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(44 Commentaires)

Hi Please check PMB Thanks Sandy

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(10 Commentaires)

Hello Sir, I have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and I am sure you will not be disappointed if you give us th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(10 Commentaires)

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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(3 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)