Advanced is the fastest in terms of processing speed. Premium and Standard are about the same in processing speed.  All are same for data input. Premium is fastest for reporting speed.  Honestly I would stay with Advanced.  I am sure Kevin has better input and thoughts.

BigLouie knows this better than I do, but I believe the transactional benefits of Advanced vs Premium are measured in fractions of a second, and depend on your hardware / system tuning  If you are running imports with 1000's of records, you might want to do some performance testing to compare.  Normal users clicking through screens shouldn't notice a difference.

Standard is fine for a very small number of users with limited data and a fast network, but because each workstation edits the raw data files over the network (instead of there being a "service" doing that work) it will always be the slowest of the three.

Performance of custom reports on Premium is light years faster than Standard / Advanced.  There is no debate on this.  SQL is king here.  On top of that, with Premium, the core data files are locked by SQL server, and can't be encrypted by crypto if a workstation is infected.

If you are on the subscription license I believe you can currently switch between the three freely.  You can try Premium, and if you want to go back down to Advanced after that, DSD has an enhancement to allow that data conversion.  Going with Advanced first, then choosing to try Premium later... can be done without 3rd party software.

BigLouie knows this better than I do, but I believe the transactional benefits of Advanced vs Premium are measured in fractions of a second, and depend on your hardware / system tuning  If you are running imports with 1000's of records, you might want to do some performance testing to compare.  Normal users clicking through screens shouldn't notice a difference.

Standard is fine for a very small number of users with limited data and a fast network, but because each workstation edits the raw data files over the network (instead of there being a "service" doing that work) it will always be the slowest of the three.

Performance of custom reports on Premium is light years faster than Standard / Advanced.  There is no debate on this.  SQL is king here.  On top of that, with Premium, the core data files are locked by SQL server, and can't be encrypted by crypto if a workstation is infected.

If you are on the subscription license I believe you can currently switch between the three freely.  You can try Premium, and if you want to go back down to Advanced after that, DSD has an enhancement to allow that data conversion.  Going with Advanced first, then choosing to try Premium later... can be done without 3rd party software.

Good information. Sage use to have a white paper on the processing speed of all three versions but I can't find it anymore but I do remember that Advanced was measurably faster than Premium.

I would advise you to do a test install on Premium first and see what issues you run into before you totally commit.

I've read that Sage had a data (or whitepaper) showing Advanced was faster than Premium but Sage took this data / white paper off the internet.