do this in sections?

jasondavis

Below is my code, is there a way to make it run like 1000 entries then do the next 1000 and so on until it has ran all in DB?

<?php

$query2 = "SELECT auto_id,fname from friend_reg_user"; 
$result2 = mysql_query($query2) or die(mysql_error());

while($row1 = mysql_fetch_array($result2)){
	$friendcount = findnooffriend($row1[auto_id]);
	$sql="insert into friend_count  (user_id,total) values('$row1[auto_id]','$friendcount')";
	$result=executequery($sql);

//	echo $row['user_id']. " = ". $friendcount;
//	echo "<br />";
}

?>

sneakyimp

Why not run all of them at once?

jasondavis

well there is over 1 million rows, just thought it would be better to do it in stages

sneakyimp

If you just want to do it once, run them all at once. If you are talking about trying to show a series of pages with prev/next buttons, you'll need to add a LIMIT clause to your query:

$first_record = 0;
$number_of_records = 1000;
$query2 = "SELECT auto_id,fname from friend_reg_user LIMIT $first_record, $number_of_records";

jasondavis

its somethnig i want to do maybe a few times a day but not have next links, have it do in a series but automated

sneakyimp

in that case, you will need to find a way to divide up the load and keep track of which records have been updated and which have not. i can think of two ways to do this:

1) add a field to friend which indicates that a friend record has been updated today. perhaps a field called 'last_updated' that contains a date. your query would need to be adjusted to fetch friend records WHERE last_updated != the current date.

2) come up with some scheme to define a different range for the LIMIT clause each time the update script runs.

Why are you unot updating the friend_count table when new friends are added? that would make a lot more sense.

jasondavis

The friend count table is actually new as of right now everythnig on my site comments, pictures, picture comments, friends, everything counts up the count as i8t is needed, Im just now switching things over to + and - from the counts, is this a better method?

sneakyimp

I don't follow what you are saying, but it sounds like you say that your code does update the friend_count table as needed but because all this code is new the counts are not currently correct.

If that's the case and you just need to update them once, I'd go ahead and just run that bad boy all in one fell swoop. If you can't because it's timingout then we can work on another approach.

jasondavis

Sorry Im saying all these areas of my site currently get the count of rows when the page is loaded, im just now changing them all over to store the count as a number in teh table and adding and subtracting from it when its needed and is this beter the my old method of counting the rows on each page load?

sneakyimp

It is better for performance if you store the count in a record and increase that value or decrease it as friends are added and subtracted. Should the count ever be off, you should probably have a function to 'recount' them all like in your code above.