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…
P. Quinn, and A. Cockburn. Proceedings of the 21st Annual Conference of the Australian Computer-Human Interaction Special Interest Group: Design: Open 24/7, page 185--192. New York, NY, USA, ACM, (2009)
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)
B. Howe, G. Cole, N. Khoussainova, and L. Battle. Proceedings of the 2011 ACM SIGMOD International Conference on Management of data, page 1319--1322. New York, NY, USA, ACM, (2011)
D. Johnson, and T. Jankun-Kelly. Proceedings of graphics interface 2008, page 163--168. Toronto, Ont., Canada, Canada, Canadian Information Processing Society, (2008)
X. Qian, Y. Yang, and Y. Gong. Proceedings of the 10th International Conference on Virtual Reality Continuum and Its Applications in Industry, page 171--178. New York, NY, USA, ACM, (2011)
M. Dörk, S. Carpendale, and C. Williamson. Proceedings of the International Working Conference on Advanced Visual Interfaces, page 233--240. New York, NY, USA, ACM, (2012)
J. Hellings, G. Fletcher, and H. Haverkort. Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data, page 553--564. New York, NY, USA, ACM, (2012)c++ sourcecode at: http://jhellings.nl/projects/exbisim/.