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…
E. Bakke, D. Karger, and R. Miller. Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, page 2541--2550. New York, NY, USA, ACM, (2011)
C. Batini, T. Catarci, M. Costabile, and S. Levialdi. Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, page 153--168. Amsterdam, The Netherlands, The Netherlands, North-Holland Publishing Co., (1992)
M. Trzaska, and K. Subieta. AVI '06: Proceedings of the working conference on Advanced visual interfaces, page 500--503. New York, NY, USA, ACM, (2006)
M. Rontu, A. Korhonen, and L. Malmi. Proceedings of the working conference on Advanced visual interfaces, page 508--511. New York, NY, USA, ACM, (2006)
G. Kurtenbach, G. Fitzmaurice, T. Baudel, and B. Buxton. Proceedings of the ACM SIGCHI Conference on Human factors in computing systems, page 35--42. New York, NY, USA, ACM, (1997)
M. Sampaio, J. Quesado, and S. Barros. Advances in Databases and Information Systems, volume 186 of Advances in Intelligent Systems and Computing, Springer Berlin Heidelberg, (2013)