[Info-vax] RMS record metadata, was: Re: Re; Spiralog, RMS Journaling (was

[lawrencedo99 at gmail.com]

On Thursday, June 23, 2016 at 8:10:37 PM UTC+12, Jan-Erik Soderholm wrote:
> But the core business applications doen't have those wildly
> dynamic SQL needs, the operations are quite well defined and
> tested. And we do not want the performance overhead with
> dynamic SQL, of course. Doing things like the Python code
> below does is totaly out of the question in high volume,
> high performance code and applications.

You do realize the query only needs to be constructed once each run, and can then return a thousand or a million or a billion records, don’t you?

Here <https://en.wikibooks.org/wiki/Python_Programming/Databases#Looping_on_Field_Breaks> is another example of a pretty traditional data-processing scenario: accumulating statistics on sales by employee.