在我们客户的情况中,增加的记录中许多指向了花费很长时间来建立索引的视图。
In the case of our customer, increased logging pointed to a handful of views taking a very long time to index.
视图中的列上的每个排序箭头都会增加视图索引,同时还会增加刷新视图的时间。
Each sorting arrow on a column in a view increases the view index and the time it takes to refresh the view.
这有助于,当然增加了查询响应时间的尖峰,每当重建索引,我想避免或减少。
This helps, but of course adds spikes in query response times whenever the indexes are rebuilt which I would like to avoid or minimize.
这有助于,当然增加了查询响应时间的尖峰,每当重建索引,我想避免或减少。
This helps, but of course adds spikes in query response times whenever the indexes are rebuilt which I would like to avoid or minimize.
应用推荐