We've now implemented the suggestion that we do an 'insert into <table>
select xxxx' and then do selects from there, and it all seems quite fast
river styx internet
On Fri, 14 May 1999, Michael Widenius wrote:
> >>>>> "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.