Comparison and analysis of the efficiency of php file read/write and database read/write

Comparison and analysis of the efficiency of php file read/write and database read/write

Set_time_limit (0 ); Function fnGet ($ filename) { $ Content = file_get_contents ($ filename ); Return $ content; } Function fnGetContent ($ filename) { $ Content = fnGet ($ filename ); Return $ content; } $ Times = 100000; Echo 'database query result: '; //--------------------------------- $ Begin = fnGetMicroTime (); For ($ I = 0; $ I <$ times; $ I ++) { $ Res = $ dbcon-> mydb_query ("SELECT log_Content FROM blog WHERE log_ID = '1 '"); $ Row = $ dbcon-> mydb_fetch_row ($ res ); $ Content = $ row [0]; } Echo 'fetch _ row'. $ times. 'time:'. (fnGetMicroTime ()-$ begin). 'second '; //--------------------------------- $ Begin = fnGetMicroTime (); For ($ I = 0; $ I <$ times; $ I ++) { $ Res = $ dbcon-> mydb_query ("SELECT log_Content FROM blog WHERE log_ID = '1 '"); $ Row = $ dbcon-> mydb_fetch_array ($ res ); $ Content = $ row ['log _ content']; } Echo 'fetch _ array'. $ times. 'time:'. (fnGetMicroTime ()-$ begin). 'second '; //--------------------------------- $ Begin = fnGetMicroTime (); For ($ I = 0; $ I <$ times; $ I ++) { $ Res = $ dbcon-> mydb_query ("SELECT log_Content FROM blog WHERE log_ID = '1 '"); $ Row = $ dbcon-> mydb_fetch_object ($ res ); $ Content = $ row-> log_Content; } Echo 'fetch _ object'. $ times. 'time:'. (fnGetMicroTime ()-$ begin). 'second '; //--------------------------------- $ Dbcon-> mydb_free_results (); $ Dbcon-> mydb_disconnect (); FnWriteCache('test.txt ', $ content ); Echo 'directly read the file test result: '; //--------------------------------- $ Begin = fnGetMicroTime (); For ($ I = 0; $ I <$ times; $ I ++) { $ Content = fnGetContent('test.txt '); } Echo 'File _ get_contents direct read '. $ times.' time: '. (fnGetMicroTime ()-$ begin).' seconds '; //--------------------------------- $ Begin = fnGetMicroTime (); For ($ I = 0; $ I <$ times; $ I ++) { $ Fname = 'test.txt '; If (file_exists ($ fname )) { $ Fp = fopen ($ fname, "r"); // flock ($ fp, LOCK_EX ); $ File_data = fread ($ fp, filesize ($ fname); // rewind ($ fp ); Fclose ($ fp ); } $ Content = fnGetContent('test.txt '); } Echo 'fopen direct Read'. $ times. 'Time: '. (fnGetMicroTime ()-$ begin).' second '; Query result of 4 K data size: fetch_row 100000 times Time: 16.737720012665 seconds fetch_array 100000 times Time: 16.661195993423 seconds fetch_object 100000 times Time: 16.775065898895 seconds Test result of direct file reading: file_get_contents reads 100000 times directly. Time: 5.4631857872009 seconds. fopen reads 100000 times directly. Time: 11.463611125946 seconds. Integer ID query result: fetch_row 100000 times Time: 12.812072038651 seconds fetch_array 100000 times Time: 12.667390108109 seconds fetch_object 100000 times Time: 12.988099098206 seconds Test result of direct file reading: file_get_contents reads 100000 times directly. Time: 5.6616430282593 seconds. fopen reads 100000 times directly. Time: 11.542816877365 seconds. Test conclusion: 1. direct file reading is more efficient than Database query, and the connection and disconnection time are not counted yet. 2. the larger the content to be read at a time, the more obvious the advantage of direct file reading (the reading time increases slightly, which is related to the continuity of file storage and the cluster size ), this result is exactly the opposite of Tian Yuan's expectation, indicating that MYSQL may have attached some operations to read larger files (two times of increase by nearly 30% ), if the conversion is simple, the difference is small. 3. write files and INSERT can be inferred without testing, and the database efficiency will only be worse. 4. if you do not need to use the database features for a small configuration file, it is more suitable for storing it in an independent file without creating a separate data table or record, it is more convenient to store large files than to store files or music files. it is more reasonable to store index information such as paths or thumbnails in the database. 5. if you only read files in PHP, file_get_contents is more efficient than fopen and fclose, not including determining whether the function will take about 3 seconds. 6. fetch_row and fetch_object should be converted from fetch_array. I have not read the PHP source code. the execution alone shows that fetch_array is more efficient, which is opposite to the online statement. It is assumed that, when the program efficiency and key process are equivalent and not included in the cache, no data of any type can be read and written directly, regardless of the MSYQL process, finally, you must read the "file" on the disk (equivalent to the record storage area). Therefore, the premise of all this is read-only content, regardless of any sort or search operations.