List:General Discussion« Previous MessageNext Message »
From:SGreen Date:August 27 2004 8:40pm
Subject:Re: 1 day 28 min insert
View as plain text  
If that were a valid SQL statement, I would agree with you. What you wrote 
**only** functions through a MySQL-specific SQL extension that permits 
non-aggregated, non-grouped columns to exist in the SELECT clause. 

I do not understand why you believe that a GROUP BY test will prove any 
sort of performance gain for his original INSERT problem.  It took just 
over 24 hours to do an INSERT IGNORE to add just about 1000 rows to a 77 
million row table. What metric of that performance will your GROUP BY test 
help to prove?

Respecfully puzzled,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


"Mikhail Entaltsev" <mentaltsev@stripped> wrote on 08/27/2004 
04:36:43 PM:

> > 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..
> 
> But it should speed up grouping by PRIMARY KEY in:
> 
> insert into 321st_stat select * from stat_in group by
> dic,niin,fr_ric,don,suf,dte_txn,sta;
> 
> Mikhail.
> 

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