List:General Discussion« Previous MessageNext Message »
From:matt ryan Date:September 1 2004 3:21pm
Subject:Re: 1 day 28 min insert
View as plain text  
Mikhail Entaltsev wrote:

>>You _could_ try adding an identical primary key to the stat_in table as
>>you have on the 321st_stat table. However, since we need all of the rows
>>from stat_in in the results, I am not sure that it will help speed up the
>>join (because it's a left join). Even though I think the index would be
>>ignored, it is worth a try to see if it would make a difference with a new
>>EXPLAIN.
>>    
>>

Tried this, setup a matching index on the temp table, it took 17 hours 
to load the input file into the temp stat_in table, so it's definitly 
not going to save me any time

I've used enable/disable keys before, but 2 problems, one it was only 5 
% faster, and two, I will have primary key violations when I enable the 
primary key, it wont enable it, at least that's my understanding of it.

Matt
Thread
1 day 28 min insertmatt ryan19 Aug
  • Re: 1 day 28 min insertAndrew Pattison19 Aug
    • Re: 1 day 28 min insertmatt ryan19 Aug
      • Re: 1 day 28 min insertSGreen19 Aug
    • Re: 1 day 28 min insertSGreen19 Aug
  • Re: 1 day 28 min insertDan Nelson19 Aug
    • Re: 1 day 28 min insertmatt ryan19 Aug
      • Re: 1 day 28 min insertDan Nelson19 Aug
        • RE: 1 day 28 min insertBoyd E. Hemphill19 Aug
          • Re: 1 day 28 min insertmatt ryan19 Aug
            • Re: 1 day 28 min insertRemigiusz SokoĊ‚owski20 Aug
              • RE: 1 day 28 min insertDonny Simonton20 Aug
  • Re: 1 day 28 min insertRhino19 Aug
  • Re: 1 day 28 min insertMikhail Entaltsev20 Aug
    • Re: 1 day 28 min insertmatt ryan27 Aug
  • Re: 1 day 28 min insertMikhail Entaltsev27 Aug
    • Re: 1 day 28 min insertmatt ryan27 Aug
      • Re: 1 day 28 min insertSGreen27 Aug
        • Re: 1 day 28 min insertMikhail Entaltsev27 Aug
          • Re: 1 day 28 min insertSGreen27 Aug
            • Re: 1 day 28 min insertMikhail Entaltsev27 Aug
          • Re: 1 day 28 min insertmatt ryan1 Sep
  • Re: 1 day 28 min insertMikhail Entaltsev27 Aug