Re: Which is faster at string manipulation and searching? RPG or SQL

On May 30, 2019, at 10:17 AM, David Gibbs via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

On 5/30/19 8:38 AM, Mark Murphy wrote:

Why do you think SQL relies on Java stack to parse regular expressions? It requires the International Components for Unicode, which has both Java and C
interfaces. Since DB2 uses C in most places, I would expect it to use C for
ICU components as well. Is there a place that tells us it uses the Java interface?

I concur with this ... I recently started using the SQL regex functions for
string analysis & manipulation... if it was invoking Java functionality, I would
have noticed the JVM startup penalty.

When invoked from a SQL RPG program, it's very fast.

david

--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding 615 miles (Yes, you read that right) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research, education,
advocacy, and awareness. You can make a tax-deductible donation to my ride by
visiting https://mideml.diabetessucks.net.

You can see where my donations come from by visiting my interactive donation map
... https://mideml.diabetessucks.net/map (it's a geeky thing).

I may have diabetes, but diabetes doesn't have me!
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

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