Re: SQL on V4: Index Optimization (Hobbyist question)

Hello Charles,

Am 24.03.2021 um 17:24 schrieb Charles Wilt <charles.wilt@xxxxxxxxx>:

You might try creating one and see if that helps.

After reading different sources about it, it doesn't seem so. I didn't
try, yet. Thanks for the hint!

While not ideal, it's perhaps possible the symbol table would be quicker

to scan than the radix index or the full table; though I guess that depends
on what else is in the table (ir. how big the rows are).

20 Chars "word", 20 chars "word, it's chars sorted alphabetically", the
word's length as numeric, and two counter rows for statistics.

Should point out that 5722-DE1 DB2 Text Extender was a chargeable

product, so if you don't already have it...you're not going to be able to
get it now.

As far as I know, modern Omnifind is java based, so probably Text Extender
was also. Java's typical overhead in terms of memory CPU, and initial time
to start a program makes me avoid it as much as possible (on any given
platform). And *especially* on an AS/400 as low-end as a 150. :-)

IMHO, you're wasting time (and electricity) with a v4r5 box...

Time: Maybe, I don't mind. Power: No. The 150 draws around 100W..120W with
four 15k disks, and is far from being used to capacity. My next faster box
— an 800 — needs 170W with just one 10k disk, and will be even less used to
capacity. Thus: Faster means no power saving here. :-)

Yes, I admit this is a very special view because I have a very special use
case. I'll think about moving to the 800 if the 150 dies an irrevocable
death, or I come up with so much meaningful/useful work that said work
accumulates faster than it can be processed. :-)

:wq! PoC


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com