Queries in web/unified view are slow if the complexity is above a certain level or they are based on another query, a feature we use all the time.
Complex queries are also impossible to read the criteria on due to the long list of specific criteria that runs off the window. For example, I'll be including or excluding dozens of appeals and can't read them all to double-check my work. When I try and view them in the edit window, it takes forever to load. If I do the same thing in database view at the same time on the same connection and device, it takes a while, but it is not impossible.