Hacker News new | ask | show | jobs
by CoffeeOnWrite 1591 days ago
How do you protect against user input that produces a psychopathic volume of indexes?
2 comments
etirk 1591 days ago
That's a problem that standard SQL tables encounter - chasing new columns with new/modified indexes. (more info at our FAQ). SFSQL never runs into that problem since the indexes are static in structure. No new indexes are made, even if every attribute name was unique. The result is a very consistent query performance.
link
rmbyrro 1591 days ago
I guess that would be on the developer side to sanitize/limit/clean in some way, like limiting the number of key-value pairs, object depth, etc?
link