3 ms·
Actually, no. You speak like database engines have to parse a query every single time it's run. That's not true - any reasonable database engine has a plan cach
by chris_wot 14y ago
Actually, no. You speak like database engines have to parse a query every single time it's run. That's not true - any reasonable database engine has a plan cache. Just because something is compiled into object code, doesn't make it that impressive.
In fact, making a plan completely stable can cause problems if the data distribution changes dramatically. I asked about this problem in a previous article about MemSQL, and the answer was that the plan won't expire unless you drop an index or add a new one. [1]
1. https://news.ycombinator.com/item?id=4126330 https://news.ycombinator.com/item?id=4126330