Ein weit verbreitetes Missverständnis steht hinter dem Mythos, dass dynamische SQL langsam ist. Für bedingte WHERE-Klauseln kann eben dieser Mythos zu Performanceproblemen fürhen.
interact.js is a standalone javascript module for handling single-pointer and multi-touch drags and gestures with powerful options such as inertia and snapping to grids or custom coordintes
"Nesting performs a join across two buckets. But instead of producing a cross-product of the left and right hand inputs, a single result is produced for each left hand input, while the corresponding right hand inputs are collected into an array and nested as a single array-valued field in the result object."
But, the person can read all rows from the table. You could try to use a view but probably, you would just implement some filtering in your proxy. “Just implement some filtering” becomes a problem when the HTTP Plugin is your proxy. There’s no script language, you can’t do that. Unless, there was a script language built-in to the proxy…
A. Hotho, R. Jäschke, C. Schmitz, and G. Stumme. The Semantic Web: Research and Applications, volume 4011 of LNAI, page 411-426. Heidelberg, Springer, (2006)
L. Page, S. Brin, R. Motwani, and T. Winograd. Proceedings of the 7th International World Wide Web Conference, page 161--172. Brisbane, Australia, (1998)