By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,830 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,830 IT Pros & Developers. It's quick & easy.

Storing XML

P: n/a
Tom
Hi,

I'm designing a website that will use XML to store all the content of my
web pages. I will use a PHP script to parse the XML. Should I store the
XML in a MySQL database or should I simply store the XML in *.xml files
on my server? Which would would yield better performance? And would
using one PHP script to parse all the pages be too much on one script
(I'll have about 600 pages)?

Thanks,

Tom
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Tom" <no****@earthlink.net> wrote in message
news:oC******************@newsread3.news.atl.earth link.net...
Hi,

I'm designing a website that will use XML to store all the content of my
web pages. I will use a PHP script to parse the XML. Should I store the
XML in a MySQL database or should I simply store the XML in *.xml files
on my server? Which would would yield better performance? And would
using one PHP script to parse all the pages be too much on one script
(I'll have about 600 pages)?


Loading a text is quicker in general than retrieving data from a database.
From a practical point of view though 10 millisec vs. 30 millsec is
insignificant, when it probably takes a full second for the client to
download the page.
Jul 17 '05 #2

P: n/a
> "Tom" <no****@earthlink.net> wrote in message
news:oC******************@newsread3.news.atl.earth link.net...
Hi,

Iím designing a website that will use XML to store all the content of my web pages. I will use a PHP script to parse the XML. Should I store the XML in a MySQL database or should I simply store the XML in *.xml files on my server? Which would would yield better performance? And would using one PHP script to parse all the pages be too much on one script (Iíll have about 600 pages)?
Loading a text is quicker in general than retrieving data from a

database. From a practical point of view though 10 millisec vs. 30 millsec is
insignificant, when it probably takes a full second for the client to download the page.

I agree with Chung that timing is not the determining factor here.
mysql also caches repeated queries, so the result set is coming back
from memory and not from the disk.

Also, you will find out soon that you want to manipulate the content
is some way, or share some of it among a number of applications, or
clean it up in some way. Then you find out that you need mysql.... so
start with mysql to have a "flexible" system IMHO.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-Storing-...ict124023.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=413681
Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.