>>>>> "unknown" == unknown <unknown@stripped> writes:
unknown> *grumble*
unknown> Ah well. We've got an alternate solution, where we just have a counter
unknown> that adds one every time a duplicate IP hits the database. Now MySQL's
unknown> crashing our machine 'coz there's too much stuff hitting it :-(
unknown> ---
unknown> tani hosokawa
unknown> river styx internet
Could you describe your problem a little better?
MySQL should not be able to crash your machine....
How do you update the counter?
UPDATE table set counter=counter+1 where ip_no=#;
should be VERY fast.
Regards,
Monty
