This is an interesting post. I agree with the second and third issues you bring up (tuning and task division), although I think that in many applications the third issue isn't sizable since it's the same developer with a different hat on :-) But you're focusing on large-scale applications so I understand.

Regarding the first issue: I'm curious if you've measured the time needed to build the queries using the methods you describe here, or others more complicated.

I like the general concept behind generating SQL statements beforehand, particularly for queries that rely on multiple tables, because it's easier to debug and to test. However, this seems to conflict with the desire of many users to perform ad-hoc queries, even if constrained by a simple web form. In cases like this, do you think it's a good idea to generate all the queries beforehand? This would seem to be a query-management nightmare since you have to account for every combination of criteria.

This might lead to a hybrid system where often-used queries are generated beforehand but ad-hoc queries are generated (partly at least) at run/request-time. I'm thinking of including something like this in SPOPS as it would add a new wrinkle to managing object relationships.

Chris
M-x auto-bs-mode

In reply to Re: Eliminating Dynamic SQL Generation with Decision Matrices for Tighter Large Scale Applications by lachoy
in thread Eliminating Dynamic SQL Generation with Decision Matrices for Tighter Large Scale Applications by princepawn

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.