Hi Brian,
Friday, October 5, 2007, 2:10:32 PM, you wrote:
> I definitely misunderstood what you guys are saying about the length.
> That's clearly a problem for a lot of my values.
> I can switch them both to bigint. One table has 34,000,000 records
> and it's OK if this is hung up for a few m
I definitely misunderstood what you guys are saying about the length.
That's clearly a problem for a lot of my values.
I can switch them both to bigint. One table has 34,000,000 records
and it's OK if this is hung up for a few minutes but not much longer
than that - any chance this change m
Hi Brian,
Friday, October 5, 2007, 1:28:35 PM, you wrote:
> This is indeed the complete code, I did not cut anything out for
> brevity, which is why this appears to be so impossible.
> eAccelerator is activated, could something be corrupt? Could a
> corrupt index cause this?
> In table1, `r
This is indeed the complete code, I did not cut anything out for
brevity, which is why this appears to be so impossible.
eAccelerator is activated, could something be corrupt? Could a
corrupt index cause this?
In table1, `referer` is int(12).
In table2, `data` is text
In table2, `friend_id`
Hi Brian,
Thursday, October 4, 2007, 4:50:09 PM, you wrote:
> I'm running the following code:
> $query3 = "DELETE FROM table1 WHERE referer=$referer ORDER BY
> creation LIMIT $numtodelete";
> $result3 = mysql_query($query3);
> $string = "$total found, $n kept, $numtodelete extras removed
> (
I'm running the following code:
$query3 = "DELETE FROM table1 WHERE referer=$referer ORDER BY
creation LIMIT $numtodelete";
$result3 = mysql_query($query3);
$string = "$total found, $n kept, $numtodelete extras removed
($query3)";
$x = mysql_query("insert into table2 (friend_id,data) values
6 matches
Mail list logo
