Welcome Guest, Not a member yet? Register   Sign In
Session Data vs. Config Variables
#3

You should try to find a way to avoid making 112 queries, one for each individual piece of content.

If menu is also built from database, you could use simple join to only select menu items that have linking content record available.

If menu is built on PHP side entierly, you could use sql IN statement to turn that 112 queries into 1 - SELECT id FROM content WHERE id IN (1, 2, ......list of checked IDs).
Reply


Messages In This Thread
Session Data vs. Config Variables - by marwin - 11-07-2018, 10:58 PM
RE: Session Data vs. Config Variables - by qury - 11-08-2018, 02:40 AM
RE: Session Data vs. Config Variables - by marwin - 11-08-2018, 03:53 AM
RE: Session Data vs. Config Variables - by Pertti - 11-08-2018, 03:33 AM
RE: Session Data vs. Config Variables - by marwin - 11-08-2018, 04:05 AM
RE: Session Data vs. Config Variables - by Pertti - 11-08-2018, 05:02 AM
RE: Session Data vs. Config Variables - by marwin - 11-08-2018, 05:41 AM
RE: Session Data vs. Config Variables - by Pertti - 11-08-2018, 09:36 AM
RE: Session Data vs. Config Variables - by marwin - 11-08-2018, 06:26 PM
RE: Session Data vs. Config Variables - by Pertti - 11-09-2018, 02:07 AM
RE: Session Data vs. Config Variables - by marwin - 11-09-2018, 02:52 AM
RE: Session Data vs. Config Variables - by marwin - 11-09-2018, 06:45 PM
RE: Session Data vs. Config Variables - by marwin - 11-09-2018, 10:27 PM



Theme © iAndrew 2016 - Forum software by © MyBB