Database sorting slower now?

Panorama X
1

It seems that a simple sort is taking more time to finish these days. A sort up on a field and then go to last record. To confirm my impression I opened the same database (from 2022) on my older Mac Air running OS 10.14.6 Mojave and PanX 10.2.1 and ran the same procedures. Both an initial pause before acting and the screen refresh take longer on my current Mac Air (M1 2020) running OS 26.1 and the latest PanX 10.2.2.

Not sure when I first felt this slothiness. One difference is that the current setup is on an Apple display, and the older comparison setup was tested with the laptop screen. Are others feeling a slowdown with databases theyve used for years?

Is there a way to lock the display in the window and then refresh/show it only when it is done sorting?

PS. I also noticed the truncated icons today in OS 26.1, which now that it was mentioned, I wonder why I didn’t notice before….

2

Now I’’m wondering if there is something slowing down that particular DB, which originated about 15 years ago and is carried forward and tweaked every year. I checked a larger file with 9114 records and 57 fields, 45 visible; versus 849 records and 73 fields, 63 visible, in the troublesome one that triggered my concern.

The same simple sort on record number or last name in the larger file is faster and doesn’t seem to pause to think or refresh the window. It is also about 3+ times faster on the newer computer OS 26.1 than on the older one with Mojave.

I wonder what I should look for in the noticeably slower DB.

3

When speaking of the Mojave OS, was that using Pano X or was that Panorma 6?

4

Pan X. Don’t think I’ve opened v6 for a few years.

5

The number of records and fields you are speaking of would have no real affect towards speed. They would not be considered ‘large’ in records nor fields by most programmers.

There is no fair comparison in the speed of a database when you throw in the different versions of Panorama and the OS. Both of those factors could easily affect the speed differences that you see.

The age of the database would only come into play if you were in one case doing things inefficiently with old code and comparing that to smarter code that was only available in a more recent version of Panorama.

I just completed rewriting old code with today’s Panorama and the runtime it took for a report to be generated went from 1.5 minutes to .5 seconds. My client was very happy.

1 Like