MapInfo Pro

 View Only
  • 1.  Variable MapInfo performance speeds between users

    Posted 03-26-2024 11:15

    Hi,

    Our setup is a central server loaded with our applications that our office of 30 remote connect to. We probably have about 10 MapInfo users. The problem we are experiencing is a rather significant difference in performance with MapInfo from one user to another. As an example, when I run my MapBasic program (which loops through a region table applying the voronoi function to each using a point table), I complete a region at an average speed of 1 per second. When my colleague runs the same program with the same data, it takes an average of 1 per minute. That's an incredible delta. Bearing in mind we might be tessellating a few thousand regions, that's a difference between the program completing within an hour, and within 2 days. 

    So what could be causing this difference? 

    a) Laptop performance - it can't be that, because the software, program and data are located on the server, so nothing is being processed by the personal laptop.

    b) Server connection - it can't really be this either, per above - nothing is being sent from the Laptop to server. 

    c) MapInfo profiles - is there anything here I could be exploring?

    d) Er, out of ideas...

    Any suggestions? It's seriously frustrating to have created programs to assist people and speed up our processes using automation only for people to complain that the programs are taking too long! It's not my fault! (hopefully!)

     



    ------------------------------
    Ryan Cook
    ORH LTD
    ------------------------------


  • 2.  RE: Variable MapInfo performance speeds between users

    Posted 03-27-2024 11:08

    Hi Ryan,

    Network issues can be manyfold from my experience. So i would suggest to run your program for testing purposes with a local dataset on both machines and see, if the performance difference stays the same. At least the outcome will narrow down the possible causes.

    best regards

    SH




  • 3.  RE: Variable MapInfo performance speeds between users

    Posted 03-28-2024 05:52

    Yeah, unfortunately we don't have MapInfo or any applications beyond MSOffice on our local machines. But I still don't understand how a connection would make a difference when we aren't really sending data back-and-forth between local and server - we are just running something on the server that we have initiated from a local machine. 

    Ran a second test yesterday. My colleague had previously run program 1 and program 2 which took 28 hours and 48 hours respectively. I ran the same programs on the same original data, and it took me 1 and 4 hours. The difference is ridiculous. 



    ------------------------------
    Ryan Cook
    ORH LTD
    ------------------------------



  • 4.  RE: Variable MapInfo performance speeds between users

    Employee
    Posted 04-02-2024 01:51

    Hi Ryan

    This process sounds like it will use queries and potentially open and close tables.

    One thing that we have found can slow down processing is the Explorer Window or the Table List window.

    They will show tables as they get opened and closed which doesn't take long for a single table but still slows down the application overall.

    Can you check if both of you have the Explorer window open?

    Can you try closing the window before running the application? You can even do this through code in your application, and then open the window when the process has finished:

    Close Window WIN_WORKSPACE_EXPLORER  'or 2004

    ...

    Open Window WIN_WORKSPACE_EXPLORER  'or 2004

    Let us know if this makes any difference



    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------