Hi All,
Id love some advice on the best way to structure the front page of a new site. Basically, I want to layout my website homepage in a series of panels, similar to the way most newspaper sites do e.g. http://www.bbc.co.uk/

I have all my stories, blog posts etc in a database so began to wonder if there is a better way than running a query such as "SELECT * from stories where channel ='XX' limit 10 " for each of the panels. On the sample link, there are channels such as sport, business, entertainment, spotlight, latest etc so this would basically be around 15 queries on the front page which doest seem to be very efficient if the front page was getting a lot of traffic. What would be the best practice used for laying out a page like this?

    Maybe a UNION of all the queries into a single query?

      Write a Reply...