If the goal of a change is to reduce the memory footprint of the database, eliminating various buffers will certainly help, at the expense of query speed and application performance.
如果一项修改的目标是减少数据库的内存占用量,那么取消各种缓冲区肯定会有帮助,但是这会牺牲查询速度和应用程序性能。
Indexes typically speed up queries, sometimes reducing the time required to execute the query to a fraction of the former elapsed time.
索引很好地加快了查询地速度,有时将执行的时间减少到以前占用时间的一小部分。
To speed searches, you may be able to rearrange your tables and, thus, simplify the underlying queries. table and SQL query optimization are highly dependent on your schema and engine.
要加速搜索,您可以重新安排表,并由此简化底层查询表和SQL查询优化高度依赖于模式和引擎。
Finally, defining appropriate XML indexes in DB2 can speed runtime query performance, as we'll discuss shortly.
最后,在DB 2中定义适当的xml索引可以提高运行时查询性能,下面马上会进行讨论。
Regular relational indexes on the unitID columns of both tables as well as on the manager column in the unit table can help speed up the embedded SQL query.
两个表的unitID列上的常规关系索引以及unit 表的manager列上的常规关系索引有助于提高嵌入式SQL查询的速度。
Running the same query a second time on Informix alone did not speed things up much because all the data would not fit in memory and the buffers were continually thrashing.
单独在Informix 上再次运行相同查询速度并没有快多少,因为无法将所有数据放入内存中,并且缓冲器一直在超负荷运转。
MySQL can speed the query phase using its query cache.
MySQL可以使用其查询缓存为查询阶段提速。
When a query is executed, the work is evenly spilt among threads. But with both hyperthreading and virtualization, those threads are not running at a consistent speed.
当执行一个查询时,所有的工作会被平均地分配到不同的线程中,但在超线程(hypertheading)或是虚拟化的环境中,这些线程并不是按照一致的速度运行的。
To speed this up, you can cache the results from a search query and use these cached results whenever a user submits a query.
为了提速,您可以高速缓存从搜索查询得到的结果,然后在用户每次提交查询时使用这些缓存的结果。
Speed is sometimes about pure performance, as in how quickly a system answers a query, but more important is the broad notion of "speed to insigt.
速度有时就是形容一个纯的处理时间,也就是系统对问题的反应有多快,但是更重要的是开阔的概念“去洞悉速度”。
For example, you can refine the query plan based on your database design, access time of the media, or CPU speed for your specific supported devices.
例如,您可以根据您的数据库设计、媒体的访问时间、或支持的特定设备的CPU速度来修改查询计划。
Tuning the Universal Server's query optimizer for particular types of complex data can vastly improve querying speed on those data types.
为特定类型的复杂数据调整万能服务器的查询优化器,能大大提高这些数据类型的查询速度。
We discovered that there is a point where aggregate index costs—more-expensive INSERT and DELETE operations, for example—outweigh a new index's query speed-up benefit.
我发现有一个聚合索引成本的点 —例如,更为昂贵的INSERT和DELETE操作 —超出一个新索引的查询加速所能带来的效益。
Performance enhancements - greatly increased indexing speed, a binary response format and a much faster delete-by query have been incorporated.
性能增强——显著提高了索引速度,二进制响应格式和快速查询删除功能。
The experiment is done, and experiment results show that the method can improve robustness, and the response speed problem of query processing is solved effectively.
用实验进行了验证,实验结果表明该方法既提高了鲁棒性,又解决了查询处理的响应速度问题。
Experimental results show that this algorithm has higher precision of document retrieval and faster computation speed compared with conventional query optimization algorithms.
实验结果表明,该算法在查询精度和计算速度上均优于常用的查询优化技术。
The query precision, the query completeness and the response speed are directly affected by which result integration algorithm is selected.
所用结果集成算法的好坏将直接影响该元搜索引擎的查询精度、查询完全度和响应速度。
Clients adopt native query, which improves reflection speed of the system.
客户端采取本地数据库查询,提高了系统响应速度。
While abnormalization design reduces joins which query requires and the number of keys and indices, can count in advance and improve the query speed.
非规范化设计减少了查询操作所需的连接,减少了外部键和索引的数量,可以预先进行统计计算,提高了查询时的响应速度;
Experimental result indicates that the model storage efficiency, query speed and has good usability and scalability.
实验结果表明,该模型的存储效率高,查询速度快,具有较好的实用性及可扩展性。
The system exhibited higher information management efficiency and query speed, as well as good applicability and guidance on ecological layout and decision support for agricultural farming.
同时系统在基于空间信息的农业生产布局与管理决策方面表现出了较好的适应性和指导性。
In hospital cost accounting, middleware technology will facilitate not only the speed on data calls, query, statistics and analysis, but also the stability and consistency on data collection.
中间件技术在医院成本核算中的应用,不仅调用查询、统计分析方便快捷,而且大大提高了数据汇总的稳定性和一致性。
You can make dramatic improvements in the speed of a query by indexing fields that are on both sides of joins, and fields that are used to set criteria for the query.
通过为联接两端的字段以及用于设置查询条件的字段创建索引,可以极大地提高查询的速度。
The query speed is one of the most important criteria in database systems.
查询速度是数据库系统中最重要的指标之一。
System has a good user interface, high query efficiency, rapid running speed, and it basically meets the management need of higher institutions on scientific research in information.
系统用户界面良好、查询效率高、运行速度快,基本满足高等院校对科研信息进行管理的需求。
Query is one of the basic and commonly using operations in DBMS. So whether the query has the fast execution speed has become a core problem for the users and designers of DBMS.
查询是数据库系统中最基本也是最常用的一种操作,因此查询是否具有较快的执行速度,已成为数据库用户和设计者极其关心的问题。
Users analyze the data and achieve decision support by submitting OLTP query, which usually needs a fast response speed.
用户通过提交联机分析处理查询对数据进行分析和决策支持,这通常需要较快的查询响应速度。
This paper proposes failed TTL-based renewal policy, which attains quicker query speed.
该文提出的基于TTL失效的再生策略,能达到很快的查询速度。
An include would again speed up that query at the expense of extra storage and extra index maintenance if any of those fields (including the included fields) were updated.
一个包括将再次加快查询的额外的存储和索引维护如果任何这些领域(包括包括字段)是更新。
In order to reduce ulteriorly retrieving range for spatial information query and to raise query speed, the retrieving technology oriented class objects in two lev…
为了便于缩小空间范围,快速地进行空间查询检索,引入了面向类对象的分级查询技术,有效地提高了空间查询的速度。
应用推荐