Re: Performance of large LF access path builds - SSD vs 10K spinny

[Gqcy <gmufasa01@xxxxxxxxx>]

a good write cache would perform better than SSD.
i.e. the CREATE INDEX was using the write cache.
what if you run a intense update application over
a) spinny disk, then b) SSD disk?



On 9/16/2014 2:59 PM, Steinmetz, Paul wrote:
> Sue,
>
> I added "unit SSD" option to both  CRTLF and CREATE INDEX.
> No impact on times, 16 minutes for both, same as original run with "Unit *any"
> While the IDX was building, I did a WRKSYSACT, I did see 4 jobs/tasks for the IDX build
>
> Conclusion.
> No difference in performance for IDX builds between SSD and 10k spinny.
>
> Am I missing something?
> Shouldn't the SSD be faster?
>
> RUNSQL REQUEST('CREATE INDEX pauls/Paullf2 ON paulssd (EKNROV, EKACEC, EKBGO6, EKCNBR, EKNUO9, EKNUPA, EKCEK6) rcdfmt EKCPTT UNIT SSD')
>
> Paul
>
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
> Sent: Tuesday, September 16, 2014 2:30 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Performance of large LF access path builds - SSD vs 10K spinny
>
> RUNSQLSTM doesn't care.
> https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014914890
> And, it's like SEU is going to give you decent prompting for sql statements anyway.
>
> It's time to ditch prompting for most of your sql statements.  iNav uses a different approach with their 'Run SQL scripts' function.  "Insert from Examples".  Even then, if you rely upon that you are going to miss out on a whole lot of function available if you RTM.
>
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to:  2505 Dekko Drive
>            Garrett, IN 46738
> Ship to:  Dock 108
>            6928N 400E
>            Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   "Steinmetz, Paul"<PSteinmetz@xxxxxxxxxx>
> To:     "'Midrange Systems Technical Discussion'"
> <midrange-l@xxxxxxxxxxxx>
> Date:   09/16/2014 02:14 PM
> Subject:        RE: Performance of large LF access path builds - SSD vs
> 10K spinny
> Sent by:        "MIDRANGE-L"<midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> Rob,
>
> What type of source member will this be?
>
> Paul
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> rob@xxxxxxxxx
> Sent: Tuesday, September 16, 2014 1:36 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Performance of large LF access path builds - SSD vs 10K
> spinny
>
> Store your CREATE INDEX in a source member.
> Submit a job that executes
> RUNSQLSTM SRCFILE(MYLIB/MYSQLSOURC) SRCMBR(MYINDEX)
>
>
> Rob Berendt