4 ms·
They looked at SQL and added an index to their DB? When I read this I actually cringed, because they changed their SQL query in production without looking at t
by ltbarcly3 16y ago
They looked at SQL and added an index to their DB?
When I read this I actually cringed, because they changed their SQL query in production without looking at the query plan first. Apparently it's the blind leading the blind over at stack overflow, not that it seems to be hurting them.
- pbz 16y ago"In production this query was taking too long, so the next step was to look at the query plan, which showed a table scan was being used instead of an index. A new index was created which cut the page load time by a factor of 10." I read it as: 1) noticed that's slow in production, 2) look at query plan (prod or dev, not clear) 3) add index (not clear if they did that in dev first and then prod)
- sams99 16y agomy dev box runs a clone of production, I do all my tuning on dev then deploy to staging, confirm it is still good there and finally ship it to production