I wanted to point out an issue we see only very occasionally, in which an Infor CRM SLX system will be very slow to access the Project files from the VFS in the database. When deploying a new version of the client site, this can cause the build step to be extremely slow. On rare occasions I have even seen the build step fail entirely because it timed out waiting for a file to be read. Infor CRM SLX is querying the database to get the content of these files, and while it is normal for this to be slower than running those same queries inside SQL, in some cases it is much slower.

Fortunately, there is a bit of chicanery I have used in the past to speed up the build process in these situations, and it has even gotten the build working in cases where it was timing out otherwise. I am not sure why this works, but I present it anyway. In cases where the build is slow, Infor CRM SLX is usually also slow to expand folders from the VFS in the Project Explorer tab of Application Architect. It appears, however, that expanding a folder here allows Application Architect to access that folder more quickly during the build process. In those cases where the build is painfully slow or even times out, I will go to Project Explorer tab and open all the top level folder, and then I will open all the second-level folders. Yes, there are dozens, and it will take a few minutes to do that, or even longer if some of those folders take a while to open. But once I have done so, the build process goes much quicker.




