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 some
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 why
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
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
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.