|
 |
13³â Àü |
PHP¿Í SQL¼¹ö¸¦ ÀÌ¿ëÇÑ À¥ÀÀ¿ëÇÁ·Î±×·¥¿¡°æ¿ì, °¡Àå °í·ÁÇÏ´Â ºÎºÐÀº Äõ¸®¹®ÀÌ°ÚÁö¿ä. Á¢¼ÓÀÚ¿Í Speed°ü°è¿¡¼, Çϵå¿þ¾îÀûÀÎ ÇÑ°è¼Ó¿£ ¼ÒÇÁÆ®¿þ¾îÀÇ Ã³¸®°¡ ÀÖ°Ú½À´Ï´Ù.
ÀϹÝÀûÀ¸·Î ´ë±Ô¸ð Æ®·¡ÇÈÀÌ ¹ß»ýÇϴ°æ¿ì´Â ÆäÀÌÁö¿¡¼ ´ÙÀÌ·ºÆ®·Î Äõ¸®¹®À» ÅëÇØ µ¥ÀÌÅ͸¦ »Ì¾Æ¿ÀÁö¾Ê½À´Ï´Ù. ±×·¡ÇÈÀ¸·Î ¼³¸íµå¸®°í½ÍÁö¸¸, ±×·¡ÇÈÅøÀÌ ¾ø´Â°ü°è·Î °£·«ÇÏ°Ô ¹¦»çÇغ¸¸é,
WebClient ---> WebServer ---> SQLServer (¾Æ·¡·Î)
WebClient <---- WebServer Return <--- SQLServer Return
À§¿Í°°ÀÌ, Webserver¿¡¼ phpÆļ¿Í°°ÀÌ Äڵ带 Çؼ®ÇÑÈÄ SQLServer·Î µ¥ÀÌÅ͸¦ ¿äûÇÏ°í, Á¤·ÄÇÏ¿© htmlÆ÷¸ËÀ¸·Î À¥Å¬¶óÀ̾ðÆ®¿¡°Ô ÀÀ´äÇØÁÝ´Ï´Ù.
±¸Çö¸ñÀû¿¡ µû¶ó ´Þ¶óÁö°ÚÁö¸¸, °Ô½ÃÆÇ°ú°°ÀÌ ½Ç½Ã°£À¸·Î Ãâ·ÂÇØÁà¾ßÇÏ´Â ÇüÅ°¡ ¾Æ´Ï¶ó¸é ºñÈ¿À²ÀûÀϼöÀÖ°ÚÁÒ.
ÀÌ¿¡, ¾Æ·¡¿Í°°ÀÌ µ¿Àû󸮸¦¸¶Ä£ ÆÄÀÏÀ» cache ÀúÀåÇÕ´Ï´Ù.
5ºÐ°£Àº Á¢¼ÓÀÚ°¡ ¸î¸íÀ̵çÁö°£¿¡, SQL¿¡°Ô µ¥ÀÌÅ͸¦ ¹¯Áö¾Ê°íµµ php¿Í Çù·ÂÇÏ¿© ÆĽÌÀ» ÇÏÁö¾Ê°íµµ À¥¼¹ö´Â ±×³É ij½ÌµÈÆÄÀÏÀ» Àоî¿Í Ãâ·ÂÇØÁÖ¸é µÇ°ÚÁÒ.
¼¹öºÎÇÏ¿Í ¼Óµµ´Â ´ç¿¬È÷ »¡¶óÁú°ÍÀÔ´Ï´Ù.
½±°Ô ¸»Çϸé, ÆÄÀÏ·Î ÀúÀåÇصΰí 5ºÐ¿¡ Çѹø °»½ÅÇØÁִ°̴ϴÙ.
1ºÐ Á¢¼ÓÀÚ°¡ 1õ¸íÀ̶óÄ¡¸é 5õ¹øÀÇ À̺¥Æ®°¡ 1¹øÀ¸·Î Áִ°ŰÚÁÒ.
(?
$reqfilename = "index";
$cachefile = "cache/".$reqfilename.".xanadu";
$cachetime = 5 * 60; //5 minutes
// Serve from the cache if it is younger than $cachetime
if (file_exists($cachefile) && (time() - $cachetime < filemtime($cachefile))) {
include($cachefile);
echo "<!-- Cached ".date('jS F Y H:i', filemtime($cachefile))." -->\n";
exit;
}
// start the output buffer
ob_start();
?)
Here is Page-Content home
(?
$fp = fopen($cachefile, 'w'); // open the cache file for writing
fwrite($fp, ob_get_contents()); // save the contents of output buffer to the file
fclose($fp); // close the file
// Send the output to the browser
ob_end_flush();
?)
|
|
̵̧ : 532 |
̵̧
¸ñ·Ï
|
|