- Code: Select all
update table_name set column1 = 'value1', column2 = 'value2' where id = '1200000'
or something similar in phpmyadmin or from the command line and see how long it takes. It may be that mysql is slow when updating such a large table.
update table_name set column1 = 'value1', column2 = 'value2' where id = '1200000'
$query = "select count(*) as num_results from table_name";
$result = mysql_query($query);
if($row = mysql_fetch_assoc($result))
{
echo $row['num_results'];
}
$query = "select primary_column from table_name";
$result = mysql_query($query);
echo mysql_num_rows($result);
Users browsing this forum: Google [Bot] and 0 guests