Flat ASCII database

[Foxter]

Script reads a flat ASCII database of about 100000 lines with 3 entries per line. It appears that script is running too slow and uses too much of system resources. Is there any way we could speed it up?

<?php
if ($page) {
	$fp = @fopen("photo.txt", 'r'); 
	$array = explode("\n", fread($fp, filesize("photo.txt")));  

	for($x=$page;$x<$page+100;$x++) {
		$temp = explode("|",$array[$x]); 
		if ($temp[0]) {
			$getdomain = parse_url($temp[0]);
			$host = str_replace($getdomain[path],"",$temp[0]);
			echo "$x - $temp[1] - $temp[2] - <A TARGET=$x HREF=\"$host\">$host</A> - <a target=$x href=\"$temp[0]\">$temp[0]</a><br>\n";
		}
	}
	$prev = $page-100;
	$next = $page+100;
	$span = "<a href=\"?page=$prev\"><< Previous 100</a> - <a href=\"?page=$next\">Next 100 >></a>";
}
else {
	$fp = @fopen("photo.txt", 'r'); 
	$array = explode("\n", fread($fp, filesize("photo.txt")));  

	for($x=0;$x<100;$x++) {
		$temp = explode("|",$array[$x]); 
		if ($temp[0]) {
			$getdomain = parse_url($temp[0]);
			$host = str_replace($getdomain[path],"",$temp[0]);
			echo "$x - $temp[1] - $temp[2] - <A TARGET=$x HREF=\"$host\">$host</A> - <a target=$x href=\"$temp[0]\">$temp[0]</a><br>\n";
		}
	}
	$span = "<a href=\"?page=100\">Next 100 >></a>";
}

$fp = @fopen("photo.txt", 'r'); 
$array = explode("\n", fread($fp, filesize("photo.txt")));
$howmany = sizeof($array);
?>

<P>
<?=$span?>
<P>Total Photos: <?=$howmany?>

[Drakla]

Use a real database with indexes that lets you not read 100000 lines when you only want 100.

[planetsim]

Well first I wouldnt read the entire file straight away. You should read it in little chunks

while (!feof($handle)) {
  $contents .= fread($handle, 8192);
}

Is an example. Then once the file is completely read you can do what you like.

[edit]Drakla beat me to it stating use a database[/edit]

[jansky]

The best thing for that is to follow what Drakla suggested

[Foxter]

Did you just hit me with mySQL? I knew you would. The database file is updated on my local system, and every morning I have to FTP it to the server. Thats Why I used ASCII database style. :bemused:

[Weedpacket]

No, not MySQL. Drakla said a real database 😉