Matthews finds that query response times "are usually at their ugliest" after a new release or a migration.
Matthews发现,在发布新版本或进行迁移之后,查询响应时间“通常非常古怪”。
Those changes cut the costs for the original query down to half and also greatly reduced the query response time.
那些更改将原始查询的成本缩减了一半,同时也极大地减少了查询响应时间。
This is especially important in the OLTP environment where transactions are huge and query response time is critical.
这在OLTP环境中尤为重要,该环境中的事务十分巨大,而且查询响应时间十分关键。
One option for authors and analysts to improve interactive query response time is to filter their reports or analyses first.
对设计人员和分析人员来说,提升交互查询时间的方法之一就是先过滤报表或分析。
This helps, but of course adds spikes in query response times whenever the indexes are rebuilt which I would like to avoid or minimize.
这有助于,当然增加了查询响应时间的尖峰,每当重建索引,我想避免或减少。
In my next column, I'll show you that there are plenty of things you can do to improve query response times without creating new indexes.
在下一个专栏中,我将向您展示,有很多方法无需创建新索引即可改善查询相应时间。
The system (or an administrator) merges stands periodically to improve performance-the fewer stands in a forest, the better the query response times.
系统(或管理员)定期合并树木以提高性能—森林中的树木越少,查询响应时间就越好。
However, when dealing with very large data sets, you can further improve the query response times of a native XML database by following a few general common sense guidelines.
但是,在处理超大型数据集时,您还可以通过遵循以下一般原则进一步改善原生xml数据库的查询响应时间。
Figure 7 shows the query response times as a function of the number of documents in the table, ranging from 1,000 to 100,000 documents (when no indexes or side tables are used).
图7显示查询响应时间作为表中文档数(范围从1,000到100,000)的函数(不使用索引或索引表)。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
通过对Oracle性能的主动和被动管理,以及优化工具SQLTrace、EXPLAINPLAN和优化器的使用,缩短了数据仓库用户查询响应的时间,提高了查询效率。
At this step, you need to use the tools discussed above to get statistics on the query: its response time, its detailed execution plan, and costs for later in-depth analysis.
在这一步中,需要使用上面讨论的工具来获取该查询的统计数据:其响应时间、详细的执行计划和成本,以便稍后进行深入分析。
The last section discussed how to apply filter predicates at the database level to improve query performance and response times.
最后一节讨论如何在数据库级应用过滤谓词,以提高查询性能和缩短响应时间。
Communications take the form of a standard message that encodes information about a query, or a response to a query.
采用标准消息的形式进行通信,对有关查询或查询响应的信息进行编码。
Similarly, one can tamper with the actual response from a legitimate query.
类似地,可以篡改来自合法查询的实际响应。
If you try the CONSTRUCT query, view the page source to see the full response.
试验CONSTRUCT查询的时候,在资源页面上可以看到完整的响应。
Make changes to your original query one at a time, and test to see if the performance has improved (decreased response time).
一次修改原始查询的一个地方,并进行测试,以查看是否提高了性能(减少了响应时间)。
Any query that utilizes the Primary Index column will encounter faster response times.
任何利用主索引列的查询将会遭遇更快速响应时间问题。
How do you measure response time and resource utilization of a SQL query?
如何测量SQL查询的响应时间和资源利用率呢?
In lab tests, the response time for the same query has been reduced from over 20 seconds down to 300 milliseconds.
在实验室测试中,同一个查询的响应时间从超过20秒大幅下降到300毫秒。
'they've come to you because they have a query and your first response needs to be that you're there to help.
他们来找你是因为他们有疑问,你的第一反应是他们需要帮助。
The information to answer the query will be sent in a response.
将在响应中发送应答该查询的信息。
You show it, or signal it. You might have raised your hand in response to her query.
如果不是通过喊话说明你在,举手示意也是对点名的回应。
Since this needs to be run in response to a user query, 30 seconds was just too long to wait.
它是要负责响应用户查询的,30秒的等待时间实在太长了.
The response time for the query was also reduced from 10 minutes to 30 seconds.
该查询的响应时间也从10分钟减至了30秒钟。
The above query would return a JSON response like what is shown in Listing 1 (omitting returned metadata about the query).
上面的查询会返回类似于清单1 的JSON响应(忽略所返回的关于查询的元数据)。
Transactional traffic — Also known as Type a, provides real-time query and response integration.
事务流量——也称为类型A,提供实时的队列和响应集成。
Listing 12b. Query a virtual system - response.
清单12b.查询一个虚拟系统-响应。
Listing 12b. Query a virtual system - response.
清单12b.查询一个虚拟系统-响应。
应用推荐