I’ve been working on a pilot project to upgrade a high usage 4.11 xtuple site to 5.00. The primary motivation is to enable integration with the Avalara tax system.
In my experience if you fail to keep your end users satisfied with the speed of the application they become very opposed to the upgrade. That is what I’ve been experiencing with the 5.0 upgrade. Everything works pretty smoothly with the exception of some of the CRM functions. A sample operation using the “cntct” table within 4.11 takes less than 2 seconds to display a screen. However the same operation within 5.00 takes 5.21 MINUTES to render the page. This is working with a cntct table that has more than 160,00 rows. Needless to say, my end users have become the enemies of the upgrade.
One of my observations is that there seems to have been a lot of usage of the CTE (Common Table Expression) within a number of the CRM metasql statements. I think this is contributing to the slow down. I personally find the usage of the “WITH” clause a very useful construct at times. I really like it however I think it may be a major performance killer within the Postgres 9.6 version we are using.
Does anyone else have any thoughts or observations on these slow downs?