I use the method outlined here and other places to avoid the costly refresh window flush cache step:
However, after uploading my database to a new web host, any relationship including a cartesian join of two globals breaks. Portal are empty, gttr steps don't work. In all cases, if I simply delete the global x global part of the relationship- everything works perfectly. Furthermore, on my desktop in FMP advanced, everything works perfectly.