reading xml faster than DB call?

Posted on 16th Feb 2014 07:03 pm by admin

I am trying to optimize a high traffic website, and I enabled a feature where there are three photos selected from the most recently submitted ones, and displayed at the top of the page. I figured that if each person is asking for 3 photos every time the page loads, this will put strain on server load. My solution involves having a script generate an xml file of the 30 most recent photos every half hour, and then cycle through the xml on the actual page. Is this a better solution than making a db call, in terms of speed gained/efficiency? I dont have much experience with XML so I wouldn't know how fast parsing it in PHP would be compared to a database call.

Your Answer:

Login to answer

Other forums

simple php table loop
Hi all,

I've the following code

<?php // Create category options

Create PHP table grid help, please
I have a MySQL database setup, now it's time for the table (gridview) design in php. Here's the prob

Lack of simpleXML Documentation
What is up with this.

Look at: http://www.php.net/manual/en/function.simplexml-load-file.php<

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']

PHP FTP connect doesn't work with correct login
Hi!

i am working on this test code:
Quote<?php

$ftp_ser

Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.
It'll do the query and then do..

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes

upload photo limits
ive got a upload photo script and im just trying to make more secure currently it limits size and as

Shuffle between users ??
I have multiple $users in table. I need to send them $message.

I need to send the next messag