Annulé

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.

Thanks

and I look forward to hearing your ideas.

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

Voir plus : caching mysql query joomla, joomla reduce queries, html5 cache, cache html5, reduce queries joomla, database caching, joomla host, queries, pm to, mysql query, make still photos, need someone makes website, html5 less, harness, database queries, single page html5, detail html5, mysql caching, component plugin, queries database, page views php mysql, query html5, photo html5, mysql page number, mysql php single page

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

N° du projet : #2360442

7 freelance ont fait une offre moyenne de 214 $ pour ce travail

ahtsolutions

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 en 8 jours
(327 Commentaires)
8.6
dinotech

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

250 $ USD en 14 jours
(44 Commentaires)
6.3
joomlarockers

Hi Please check PMB Thanks Sandy

200 $ USD en 4 jours
(10 Commentaires)
4.5
JoomlaVogue

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

200 $ USD en 20 jours
(10 Commentaires)
4.4
jkadziola

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

200 $ USD en 7 jours
(0 Commentaires)
0.0
reformconsulting

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 en 7 jours
(3 Commentaires)
3.2
tenacioustec

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 en 7 jours
(0 Commentaires)
0.0