On Tue, 04 Mar 2008 08:18:08 -0500, Phil wrote:
> Just inheritance from an old design that has passed it's limits.
Just checking :)
I was talking to someone about redundancy in a table and he was like
"that's good though, because there are multiple (blah, blah, blah)...but
it does screw up som
Just inheritance from an old design that has passed it's limits.
I actually have a development version which does just that, but there is a
lot of work to convert many php scripts and sql to include the new column.
It's some way away from live though, so the problem I outlined still exists.
Phil
On Thu, 28 Feb 2008 11:19:40 -0500, Phil wrote:
> I have 50 plus tables lets call them A_USER, B_USER, C_USER etc which I
> daily refresh with updated (and sometimes new) data.
>
> I insert the data into a temporary table using LOAD DATA INFILE. This
> works great and is very fast.
May I ask wh
Just a little more info on this.
I tried setting all of this up on a home server with, as far as I can see,
more or less identical specs with the exception being that it's a 64bit
linux build rather than 32bit.
Same insert on duplicate update takes 3 mins.
I spent all day yesterday trying to fig
I'm trying to figure out which limits I'm hitting on some inserts.
I have 50 plus tables lets call them A_USER, B_USER, C_USER etc which I
daily refresh with updated (and sometimes new) data.
I insert the data into a temporary table using LOAD DATA INFILE. This works
great and is very fast.
Then
