Question

Connection Pool Issues

Forum|Forum|3 years ago
July 3, 2023
12 replies
0 views

Hi Everyone,

We have a requirement where Application is writing 500 rows parallely via startprocess smart service(Loop).

Now for every Write opertion sync will run that means sync will run 500 times in backend. It seems to be creating connection pool issue
though connection pool is 200.

can some one suggest the best soultion in this case?

Thanks in Advance!!

mikes0011

Brainy

Could the 500 rows (or any subset of them) be written in one instance, versus looped?

G

gopuhAuthor

500 instances are running parallely where each instnace is writing a row in db.

mikes0011

Brainy

Yes, that's what you said originally. And I'm asking if there's any way to restructure this, so that all 500 of those writes could be done in a single instance somehow. Because it sounds as if you're referring to 500 instances that are launched and write 100% simultaneously, which leads me to conclude that it might be possible, instead of launching 500 instances, to launch 1 instance with 500 rows (or 5 instances with 100 rows each, etc...).

mathieud0001

Any reason why you need to do 500 writes vs just 1 write (and 1 sync with multiple ids)?

G

gopuhAuthor

It is an upload process where each row in an excel is prcessing separtely in each instance. So when an instance is writing a row into db, sync happening

mikes0011

Brainy

each row in an excel is prcessing separtely in each instance

Is there a particular reason why each row requires a separate instance to be launched for it?

Sign up

Login with SSO

Login to the community

Login with SSO