<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[TNF : Tatter Network Foundation forum - 태터툴즈 사용시 mysql 부하 관련]]></title>
		<link>http://forum.tattersite.com/ko/viewtopic.php?id=4334</link>
		<description><![CDATA[태터툴즈 사용시 mysql 부하 관련 의 최근 RSS 글들.]]></description>
		<lastBuildDate>Thu, 03 Jan 2008 09:45:21 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[태터툴즈 사용시 mysql 부하 관련]]></title>
			<link>http://forum.tattersite.com/ko/viewtopic.php?pid=23140#p23140</link>
			<description><![CDATA[<p>태터툴즈를 사용하다보면 요즘 부적&nbsp; mysql 슬로우쿼리부분에서 <br />SELECT count(r.entry) `cnt` FROM `tt_TagRelations` r,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; `tt_Entries` e<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE r.entry = e.id AND e.visibility &gt; 0 AND r.owner = 1<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GROUP BY r.tag<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORDER BY `cnt`<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LIMIT 1;<br />해당 내용 문구가 자주 발생합니다. . <br />그래서 서버에 부하가 너무 심하네요!~~ <br />해결 방안좀 말씀해주세요</p>]]></description>
			<author><![CDATA[null@example.com (신군)]]></author>
			<pubDate>Thu, 03 Jan 2008 09:45:21 +0000</pubDate>
			<guid>http://forum.tattersite.com/ko/viewtopic.php?pid=23140#p23140</guid>
		</item>
	</channel>
</rss>
