Author Topic: Any available tests to measure a DBMS repository performance?  (Read 3987 times)

bockfu

  • EA User
  • **
  • Posts: 55
  • Karma: +4/-1
    • View Profile
Any available tests to measure a DBMS repository performance?
« on: August 27, 2016, 02:36:31 pm »
I am looking for a way I can measure the performance of my DBMS repository accessed from different geographical locations.

In general, the performance/usability of the UI goes down the further the EA app is from the DB Server.  I am looking for a way to measure the performance so we can baseline different configurations.

Anyone have any tips or something to share to baseline performance for this context?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Any available tests to measure a DBMS repository performance?
« Reply #1 on: August 27, 2016, 07:20:53 pm »
Create a big diagram with many elements. Then try to work with that (dragging elements) and see how it works out.

q.

bockfu

  • EA User
  • **
  • Posts: 55
  • Karma: +4/-1
    • View Profile
Re: Any available tests to measure a DBMS repository performance?
« Reply #2 on: August 28, 2016, 12:18:39 am »
Any tips on measuring performance?   For example, should I script this, capture start time, open diagram, move element X from a,b to c,d, then save diagram, move element X from c,d to a,b the. Save diagram.  Capture end time. Calculate total time.

That is logically what I have been thinking.  Just wanted to run it by the forum to see if that was an appropriate approach.