Fw: Speed of the PHP Parser MySQL vs. textfiles
| From: | Holger Heinze, Portalmeister GmbH | Date: | Wed, 25 Sep 2002 16:51:53 +0000 |
| Subject: | Fw: Speed of the PHP Parser MySQL vs. textfiles | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-117590@lists.php.net to get a copy of this message | ||
Hi people, maybe someone here has experience with this question:
We have to create a CMS System for beginners. For storing data, we have 3
possibilities:
--------------------
1. Store Data in MySQL, query the database, inlcude the dynamic content via
php.
echo $mysqldata[headline]."<P>\n";
--------------------
2. Store Data in Textfiles holding the Data like this:
<?
$userpreferences[headline] = "My Headline";
$userpreferences[bgcolor] = "#00FF00";
// etc.
?>
This would mean, we just include the preferences file at the top of the php
script generating the output page. (A lot less coding i think)
--------------------
3. Generate HTML pages (soc. cache) everytime the user makes changes to his
pages.
--------------------
I just had an argument with a co-worker and I would like to have your guys'
opinion on this:
Combination 1: Store frequently changed info in 1. MySQL Database and rarely
changed data in 2. Textfiles that are included.
Combination 2: Store frequently changed info in 1. MySQL Database and rarely
changed data in 3. Plain HTML Cache files.
I won't say which one is mine! ;-)
So, which one would you guys prefer, and what do you think is faster ...
Included Textfiles or HTML or MySQL ?
We also of course have to take the time and complexity of the coding into
consideration.
Thanks a lot for any answer!
(Also thankful for urls to php parser benchmarks etc...)
Holger Heinze