Fw: Speed of the PHP Parser MySQL vs. textfiles

From: 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

« previous php.general (#117590) next »