Rocket OpenQM

 View Only
  • 1.  MVconnect response time

    Posted 06-16-2023 15:26

    We have a number of PHP pages that access QM on another server.  

    Our response time is slow by my standards.

    we have added some pretty significant logging to our process. We know the pageload time in PHP, we know the time for the function call to QM, and we know the QM response time. We getting some variability in response time as well with no patter that we can see.

    Our OpenQM server is in Azure and running on W2019. Our web server is on a private server running Apach and linux.

    we are using our url name and port 8280 as normal

    http://web.xyz.com:8280/api/

    we are seeing times of 1.723 seconds to get the function and pageload in PHP. The QM side takes 8ms .

    we have been looking that the flush time on MVCONNECT, this seems to make no appreciable difference.

    we are off checking to make sure nothing on the windows server is grabbing this, such as virus checker or something.

    we down to internet time.

    Looking for suggestions on best practices.  Should we make a private tunnel from linux to QM?

    do people put the DB server on the same box as the webserver ?

    Can anyone point us in a direction to speed this up and/or do this in the right away?  We have probably 20 PHP pages, and some making multiple calls to the DB.



    ------------------------------
    Jesse Tillia
    Rocket Forum Shared Account
    ------------------------------


  • 2.  RE: MVconnect response time

    PARTNER
    Posted 10-03-2023 10:51

    We have found MVConnect (tested in jBase and OpenQM) to be sluggish when building large responses if you use the MVConnect Object functions to build the JSON response. In OpenQM we leverage the built in Collections for our jSON and only use the WSEND routine to post the data and our performance improved significantly.



    ------------------------------
    Justin Orton
    Owner, Solution Architect
    Technical Plus LLC
    kissimmee FL US
    ------------------------------