Can someone tell me if what I'm trying to do can be done more efficiently? I
just got off the phone with Rackspace when my server was hung up, and they
found a whole bunch of this one same query was all stacked up with waiting
queries and locked.
Here's the query:
$query = insert ignore into
- Original Message -
From: Brian Dunning br...@briandunning.com
Can someone tell me if what I'm trying to do can be done more
efficiently? I just got off the phone with Rackspace when my server
was hung up, and they found a whole bunch of this one same query was
all stacked up with
Can you rotate that table daily, thus keeping it small?
You can then move yesterdays data somewhere for post processing.
try an insert if it fails generate the new table from the template, done.
Thus no checking other then once a day when the insert fails.
On Wed, Oct 19, 2011 at 2:54 PM, Johan