JA Job Board Component 8,554 posts

[pbaddock Friend pbaddockJoin date: September 2006Posts: 3Downloads:0Uploads:0]

#162063

Hello all,

My JA Jobs instance (http://www.jobloker.co.id) is putting a pretty heavy load on the dB (web server is fine) and my tech team are telling me that there are a pretty high number of slow queries (tables lacking indexes).

I’m aware of the caching options available, but are there any suggestions or previous experiences we can leverage on dB optimisation with this component. We are about to embark on our own optimisation, but would appreciate any suggestions before we do this.

Phil

JobLoker &
Salsa Internet

[Vinh CV Friend Vinh CVJoin date: August 2009Posts: 574Downloads:0Uploads:2 Thanked: 76 times in 72 posts]

#383747

Hi pbaddock,

Thanks for your report!

We are fixing this issue for the next version http://pm.joomlart.com/browse/JAJB-780

[pbaddock Friend pbaddockJoin date: September 2006Posts: 3Downloads:0Uploads:0]

#383810

Thanks for that, we’ll have a look at some of the indexing suggestions – appreciate your help. If we identify any other quick wins, I’ll post again. 🙂

[sharpdome Friend sharpdomeJoin date: December 2010Posts: 247Downloads:6Uploads:4 Thanks: 62 Thanked: 5 times in 1 posts]

#384206

If you’re able to find other DB optimizations beyond the ones in http://pm.joomlart.com/browse/JAJB-780 , I’d love to hear about them! 🙂

[Author]

Posts