Mal1 Posted November 14, 2012 Share Posted November 14, 2012 I'll state that I'm a complete amateur when it comes to programming in case I'm not clear or I say something that doesn't make sense. I have two websites which have evolved over the years with different programmers at different times - www.little-persia.com and www.love-rugs.com. I look after both cosmetically and have worked out various issues with javascript, php etc. over the years by just researching and teaching myself/using common sense/problem solving. However I'm stumped. Little-Persia is really fast when it comes to searches (page changes in under 2 seonds and images load within another second) yet Love-Rugs is unbearably slow (I hit search and the page hangs for about 12 seconds before doing anything). I think I've worked it out as having little to do with page sizes/image load times etc. and more to do with number of queries. Load times are at their worst for a blank search - if I put in a few filters in an advances search the load times become bearable (although still not great or anywhere near the same speed as Little-Persia). The two websites have different tables with Love-Rugs loading information on stock levels/size and price from one and general details from another. Little-Persia is all individual products (don't come in a variety of sizes/prices) so all their info is stored on one table. I'm trying to obviously figure out how to speed it up and/or remove unnecessary queries but to do that I need to find out where they're originating. Is there a way to do this? Quote Link to comment https://forums.phpfreaks.com/topic/270673-find-where-queries-originate/ Share on other sites More sharing options...
trq Posted November 14, 2012 Share Posted November 14, 2012 If I was in your position, I would hire a programmer. In order to optimise code, you first need a pretty good understanding of it. Quote Link to comment https://forums.phpfreaks.com/topic/270673-find-where-queries-originate/#findComment-1392254 Share on other sites More sharing options...
Mal1 Posted November 14, 2012 Author Share Posted November 14, 2012 (edited) Is there any sort of diagnostic tool or check I could do to try to at least find out what would be causing it? At least then if we were to get a programmer we'd know where to direct them. Edited November 14, 2012 by Mal1 Quote Link to comment https://forums.phpfreaks.com/topic/270673-find-where-queries-originate/#findComment-1392342 Share on other sites More sharing options...
fenway Posted November 16, 2012 Share Posted November 16, 2012 You can turn on the slow query log. Quote Link to comment https://forums.phpfreaks.com/topic/270673-find-where-queries-originate/#findComment-1392830 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.