Using Query Builder, I built a query with 16 tables- 8 fields in the ‘select’ statement, 9 fields in the ‘where’ statement, and 4 sub queries in the ‘where’ statement. I will acknowledge that I am not a DBA or a developer. I know SQL well enough- with 20 years experience (10 with Hyperion/Brio)
In any case, I organized the tables in a 4x4 grid to help better visualize the tables and the fields. I found it very very difficult to navigate the query builder work space with so many tables.
First, managing what I have in the ‘select’ and the ‘where’ clause was so confusing and cumbersome because I had to constantly scroll left and right/up and down. In addition, in couple of fields that were not in the ‘select’ statement, I had complex sub-queries in the ‘where’ clause. On two instances, I accidentally clicked on the field name in the table window in the QueryBuilder work space and the field was removed work space at the bottom of the screen (select, where, having clauses).
Second, if I was joining a field from table A1 to D4, the window would not auto scroll down while I was dragging the field from table A1 to D4 (on a grid). I zoomed out as much as I could before it became difficult to read the field names in the table windows.
Third, the GUI feedback from the application was slow as a turtle. And I encountered 2 out-of-memory exception, freezes, and GUI residues (window outline, drag marks, etc.). TDP is running on an i7/3.4GHz, Win7 with 20gb ram connected to a 23 inch monitor.
QueryBuilder feature was one of decision making features for purchasing TDP. In building this query, the whole experience with QueryBuilder was just awful and very very frustrating.
Is there anything in the works to improve the QueryBuilder experience?