Generera XML filer från en databas

Hej,

Jag ska generea x antal XML filer med info från en databas.
Varje fil kommer innehålla ~1.000 rader och jag har löst det såhär:

$fext = "_" . time() . ".xml";
for($i = 0; $i < sizeof($language); $i++){
	
	$query = "SELECT "
		."a.group_id, a.group_name, a.group_desc, "
		."b.item_id, b.item_parent, b.item_name, b.item_desc, b.item_cdata, "
		."(SELECT value_text FROM phrase_value WHERE value_parentid = b.item_id AND value_language = 1 ORDER BY value_updated DESC LIMIT 1) AS str_english, "
		."(SELECT lang_code FROM document_lang WHERE lang_id = " . $language[$i] . " LIMIT 1) AS lang_code, "
		."(SELECT lang_code_short FROM document_lang WHERE lang_id = " . $language[$i] . " LIMIT 1) AS lang_code_short "
		."FROM phrase_group a INNER JOIN phrase_item b "
		."ON a.group_id = b.item_parent "
		."WHERE a.group_parent = 3 "
		."ORDER BY a.group_order ASC, b.item_order ASC";

	$result = mysql_query($query) or die((DEBUG ? "<h2>An error occurred</h2>\n<p>" . mysql_error() . "<br />\n" . $query . "</p>\n" : "<p>An error has occurred, please contact site admin.</p>\n"));
	if(!(mysql_num_rows($result) == false)){
		$i = 0;
		$curr_group = 0;
		$lang_code = mysql_result($result, 0, 9);
		$lang_code_short = mysql_result($result, 0, 10);
		$fp = fopen(ROOTPATH . "upload/XML/text." . ($filename == 1 ? $lang_code : $lang_code_short) . $fext, "w");
		fwrite($fp, "<?xml version=\"1.0\" charset=\"utf-8\">\n"
			   ."<Resource>\n");
		mysql_data_seek($result, 0);
		while($res = mysql_fetch_assoc($result)){
			if(!($curr_group == $res['group_id'])){
				if($i != 0){
					fwrite($fp, "\t</items>\n"
							   ."\t</group>\n");
				}
				fwrite($fp, "\t<group id=\"" . $res['group_name'] . "\">\n"
					   ."\t<desc>" . $res['group_desc'] . "</desc>\n"
					   ."\t<items>\n");
			}
			$query = "SELECT "
				."a.value_text "
				."FROM phrase_value a "
				."WHERE a.value_parentid = " . $res['item_id'] . " "
				."AND a.value_language = " . $language[$i] . " "
				."AND a.value_updated = ("
				."	SELECT "
				."	MAX(value_updated) "
				."	FROM phrase_value pv "
				."	WHERE pv.value_parentid = a.value_parentid "
				."	AND value_language = " . $language[$i] . " "
				.") "
				."LIMIT 1";
			
			$val = mysql_query($query) or die((DEBUG ? "<h2>An error occurred</h2>\n<p>" . mysql_error() . "<br />\n" . $query . "</p>\n" : "<p>An error has occurred, please contact site admin.</p>\n"));
			if(!(mysql_num_rows($val) == false)){
				$value_text    = mysql_result($val, 0, 0);
			}else{
				$value_text    = $res['str_english'];
			}
			mysql_free_result($val);

			fwrite($fp, "\t\t<item id=\"" . $res['item_name'] . "\">\n"
				   ."\t\t\t<value>" . $value_text . "</value>\n"
				   ."\t\t\t<desc>" . $res['item_desc'] . "</desc>\n"
				   ."\t\t</item>\n");

			$curr_group = $res['group_id'];
		}
		fwrite($fp, "\t</items>\n"
			   ."\t</group>\n"
			   ."</Resource>");
	}
	mysql_free_result($result);
        fclose($fp);
}

$language är en array med id'n över de språk som ska genereras.
Det går jättefint att generera en fil, den sparas i rätt mapp och innehåller alla rader.

Men när jag väljer två språk, så att for-loopen går två varv, så skrivs aldrig fil #2 klart, den innehåller inte alla rader.

Sen tar det flera minuter att exekvera skriptet.

Finns det några andra smart sätt att lösa det här?

Tack!