Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
shedder

New Member
Registered:
Posts: 1
Reply with quote  #1 
Hi,
We have recently been carrying out some performance analysis on our MS SQL2005 database using SQL Server Profiler and it has become apparent that all form Grids in our Metastorm v7.5 (Sp1 hotfix7.5.1.7) solution query the database twice with exactly the same data query!


I have created a new map and dropped a Grid on it. Set the Table(s) to some local table (Users) and set up a couple of columns (Username,Surname) and publish the map.

If I then setup a SQL trace on the DB and open the form you see all the expected Metastorm sql activity but 2 hits one after another on the database getting the user data.
eg
SQL:Batch Completed   SELECT Username,Surname FROM Users 
SQL:Batch Completed   SELECT Username,Surname FROM Users 


The wasted hit in this example is not a big deal but on some meaty queries this is causing problems.
Our DBA's are not impressed that we a wasting half of the DB resources whenever we need to display the contents of a DB table or results of a DB Query.

Any ideas how we can stop this?

Thanks

Paul
0
Doogal

Avatar / Picture

Guru
Registered:
Posts: 1,564
Reply with quote  #2 

Just checked in 7.6 and I'm seeing the same thing. I'd also be interested to know why this is happening. I'd suggest asking Metastorm

0
oelversk

Avatar / Picture

Senior Member
Registered:
Posts: 74
Reply with quote  #3 
Is Grid Type set to Field has dependants or is Field is dependant on another set?

/Ola

__________________
The Truth is Out There!

Business Dynamics Svenska AB
0
Doogal

Avatar / Picture

Guru
Registered:
Posts: 1,564
Reply with quote  #4 

No, seems to happen with a grid with nothing set

0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!