search

IBM / db2sock-ibmi

An asynchronous PASE Db2 and IBM i integration library
MIT License
4 stars 7 forks source link

Do not make db connection when using in memory call #28

Closed kadler closed 6 years ago

kadler commented 6 years ago

Original report by Teemu Halmela (Bitbucket: teemu_, GitHub: Unknown).

We shouldn't make a db connection or allocate a handle when it isn't needed. It slows things down.

FIX1
FIX2

kadler commented 6 years ago

Original comment by Teemu Halmela (Bitbucket: teemu_, GitHub: Unknown).

Looks good, thank you.

kadler commented 6 years ago

Original comment by Tony Cairns (Bitbucket: rangercairns, GitHub: rangercairns).

Ok, i have 'no connect' when using memory call option with PGM or CMD. Yes, screaming fast. Yes, could be even faster if cache pgm resolves (devil may care security issues though).

warning

However, again (reminder), even with memory option, all json operations for qsh, rexx, and db2 are still using a db2 connection (slower).

Why?

Of course json db2 operations need a connection (obvious). Also json qsh and rexx are already slow (not wasting my time making slow-as-snail shell like operations go a little faster).