Ask a Question

does writing queries directly against process server database cause performance bottlenecks?

0 votes
458 views
in Interview Questions by (16.3k points)

1 Answer

0 votes
by (1.3k points)
if your query introduce locks to bpm system table, bpm will be impacted.for sure.

Related questions

0 votes
1 answer 509 views
Is your Process Runtime Data stored plain text in the Process Server Database?
asked Apr 5, 2018 in Process Server by Anil Singh (16.3k points)
0 votes
1 answer 1.0k views
Introducing a Free Tool to Manage Process Server and Perform Performance Tuning.
asked Aug 28, 2018 by BPM Tips Admin (21.6k points)
0 votes
1 answer 778 views
What is cometd and its impact on Process Server Performance ?
asked Apr 5, 2018 in Process Server by Anil Singh (16.3k points)
0 votes
1 answer 908 views
What are the default JNDI names for Process Server, Performance Data Warehouse?
asked May 15, 2016 in Integrations by anonymous
+1 vote
1 answer 1.0k views
Are stored procedures better than sql queries to fetch data and why?
asked Jun 19, 2019 in Interview Questions by Anil Singh (16.3k points)
0 votes
0 answers 614 views
How does IBM BPM compare to other BPM platforms like jBPM, Pega, Camunda?
asked Mar 30, 2020 in Interview Questions by Anil Singh (16.3k points)
0 votes
1 answer 814 views
How does conversion from HHS to CSHS work ?
asked Nov 14, 2018 in Interview Questions by BPM Tips Admin (21.6k points)
0 votes
0 answers 293 views
How does a process communicate back to Case management?
asked Apr 9, 2020 in IBM BPM Case Management by Anil Singh (16.3k points)
0 votes
0 answers 811 views
How to change the SMTP configuration of Process Server?
asked Mar 30, 2020 in IBM BPM Infrastructure by Anil Singh (16.3k points)

635 questions

495 answers

98 comments

3.2k users

Join BPM Community Discord Channel

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel

Categories

Most popular tags

#ibmbpm bpm baw ibm #coachviews workflow #integrations ecm bpm-ibm toolkits portal java #baw validationerror webdesigner processdesigner - coachview stored validation database procedure team rest migration #text-rich #client-side #texteditor #heritage #heritagehumanservice #hss bpd-integrations bpmservices ibmbpm notreachanble humanservices @username #ibmbaw#ibmbpm#baw#table #error migration- #bpm #eventhandler #bpmadmin #function #button debugger pet filenet cometd #production #processcenter #processserver log4j breadcrumbs careers jobs html- css- crumb- io pdf hierarchy inspector authentication cmis bread responsive section dependency db2 enterprise package tab dashboard artifact file page query email views start filter center ui playback standard rules bal decision js search service bpd variables integrations coaches services coach process 5
Powered by Dosvak LLC
...