MySQL Forums
Forum List  »  PHP

Re: Server lag or join problem?
Posted by: Robert Summerfield
Date: April 06, 2017 03:51AM

I have just tested speeds by splitting my statement into 2 returning the images separately, speed is infinitely faster, 0.0858 seconds to return articles and categories, 0.0102 seconds to return each image. However I have always been of the understanding that a join is more efficient as it requires fewer calls to the database. Based on a limit clause of 12, a join would require a single call splitting would require 13 calls!
The speeds tests suggest I should split, am I right?

Options: ReplyQuote


Subject
Written By
Posted
Re: Server lag or join problem?
April 06, 2017 03:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.