Re: Server lag or join problem?
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?
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.