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.
任何利用主索引列的查询将会遭遇更快速响应时间问题。
Those changes cut the costs for the original query down to half and also greatly reduced the query response time.
那些更改将原始查询的成本缩减了一半,同时也极大地减少了查询响应时间。
How do you measure response time and resource utilization of a SQL query?
如何测量SQL查询的响应时间和资源利用率呢?
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)的函数(不使用索引或索引表)。
In lab tests, the response time for the same query has been reduced from over 20 seconds down to 300 milliseconds.
在实验室测试中,同一个查询的响应时间从超过20秒大幅下降到300毫秒。
This is especially important in the OLTP environment where transactions are huge and query response time is critical.
这在OLTP环境中尤为重要,该环境中的事务十分巨大,而且查询响应时间十分关键。
'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响应(忽略所返回的关于查询的元数据)。
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数据库的查询响应时间。
Matthews finds that query response times "are usually at their ugliest" after a new release or a migration.
Matthews发现,在发布新版本或进行迁移之后,查询响应时间“通常非常古怪”。
With the back end defined, you can now use PHP to query the Arduino, analyze the response, and store the observations in the back end, as shown in Listing 4.
定义好后端之后,现在就可以使用php来查询此Arduino、分析响应以及在后端存储观察结果,如清单4内所示。
If you enable the spell correction function during the query preparation, the response object provides the Suggestions proposed by OmniFind for the query words.
如果在查询准备期间启用了拼写纠正,那么响应对象会提供OmniFind对查询词提出的建议。
Listing 12b. Query a virtual system - response.
清单12b.查询一个虚拟系统-响应。
You can HTTP POST an RDF query document to a MusicBrainz server, and get a response back in MusicBrainz metadata form similar to that in Listing 1, but with CDMP wrapper elements.
可以将RDF查询文档使用HTTPPOST放到MusicBrainz服务器,然后获得与清单1类似的以MusicBrainz元数据格式表示的响应,但是带有CD MP封装器元素。
Media query Listeners - enables running a script in response to a change in the media query (for eg switching between low and high res image sources depending on window size).
MediaQueryListeners——可以运行脚本以响应媒体查询的变化(比如说根据窗口尺寸在高低清晰度的图片间进行切换)。
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.
在这一步中,需要使用上面讨论的工具来获取该查询的统计数据:其响应时间、详细的执行计划和成本,以便稍后进行深入分析。
Client applications query a data mediator service and get a data graph in response.
客户机应用程序将查询数据中介服务,并从响应中得到数据图。
The system (or an administrator) merges stands periodically to improve performance-the fewer stands in a forest, the better the query response times.
系统(或管理员)定期合并树木以提高性能—森林中的树木越少,查询响应时间就越好。
One option for authors and analysts to improve interactive query response time is to filter their reports or analyses first.
对设计人员和分析人员来说,提升交互查询时间的方法之一就是先过滤报表或分析。
Client applications can query a DAS and get a data graph in response, modify the data graph and send the updated data graph to a DAS to have the changes applied to the original data source.
客户机应用程序可以查询DAS并得到数据图表作为响应,修改数据图表并向DAS发送更新的数据图表,以便将这些更改应用到原始数据源中。
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.
在下一个专栏中,我将向您展示,有很多方法无需创建新索引即可改善查询相应时间。
应用推荐