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
------------------------------
Original Message:
Sent: 03-26-2024 11:15
From: Ryan Cook
Subject: Variable MapInfo performance speeds between users
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
------------------------------