理解并正确使用RUNSTATS是维护高性能数据库的关键之一。
Understanding and properly using RUNSTATS is one of the keys to maintaining a high-performing database.
高性能、前沿产品以及简单调优意见和建议的正确结合可以带来优秀的数据库性能和可伸缩性。
The right combination of high-performance, leading-edge products, along with simple tuning advice and recommendations, can result in excellent database performance and scalability.
对于从数据库选择大量数据的情况,这可以是一个内部表,这有助于提高性能。
This can be an internal table for bulk selects from the database, which has performance advantages.
它简化了数据库的配置,确保最高效地利用可用内存并提高性能。
It simplifies database configuration, ensures most efficient utilization of available memory and improves performance.
性能对于任何数据库都很重要,但是在嵌入式场景中,在实现高性能的同时必须保证性能的一致性和可预测性。
Performance is important for any database server, but in an embedded scenario, high performance must be accompanied by consistency and predictability.
这种解决方案的缺点是,数据库服务器引入了新的单点故障(SPOF),并且不适合那些需要高性能的应用程序。
The disadvantages of this solution is that the database server introduces a new single point of failure (SPOF) and may not be suitable for applications that require high performance.
为了提高性能,这种方法应允许中间层重用相同的物理连接,而不需要重新在数据库服务器上对用户进行身份验证。
In order to maximize performance, the approach is to allow for the middle tier to reuse the same physical connection without the need to re-authenticate the user at the database server.
大约6个月前,我们决定开发一个全新的现代搜索框架,该搜索框架基于高性能的倒排索引,而非关系型数据库。
About 6 months ago, we decided to develop a new, modern search architecture that is based on a highly efficient inverted index instead of a relational database.
为实现高性能、灵活性以及相关排序等,一些搜索引擎与数据库直接相连,从数据库提取数据并生成索引。
To achieve high performance, flexibility, relevance ranking, and so on, some search engines connect to databases directly, extract data, and generate indexes from databases.
使用InfoSphereReplicationServer达到提取数据的高性能的关键是所有主要相关数据库都使用日志来记录数据库变化。
The key to achieving high data extract performance with InfoSphere Replication Server is the fact that all major relational databases use a log to record changes to the database.
10gen开发并支持MongoDB,一个开源、高性能、可扩展、面向文档的数据库。
10gen develops and supports MongoDB, the open source, high performance, scalable, document-oriented database.
我们已经进一步简化并跳过了Do记录,但是大型和高性能的数据库可能会用到它们,为此我们做了很多工作(在下面的步骤中用法会变得清晰)。
We could have simplified even further and skipped the Do records, but sizeable and high performance databases would probably use them, so we did too (usage becomes clear in the following steps).
通常来说,将其设置为True会提高性能,但这样做无法在数据库事务中保持数据库更新的顺序。
Generally, setting it to True improves performance, but this does not preserve the ordering of database updates within a database transaction.
这将极大地提高性能,因为数据库节约了对相同的查询反复计算执行计划所需的所有开销。
This improves performance chiefly because the database saves all the overhead involved with calculating the execution plan for the same query over and over.
这可以大大提高性能,因为这样减少了客户机应用程序与数据库服务器之间零散的数据传输。
This can provide a performance boost, as it results in fewer individual transmissions of data between the client application and the database server.
这意味着当您针对数据库运行多个应用程序并且在非常短的时间范围内应用程序请求大量提交时可以提高性能。
This can mean improved performance when you have multiple applications running against a database and many commits are requested by the applications within a very short time frame.
如果连接到数据库的应用程序主要执行更新数据的事务,那么增加清除程序的数目会提高性能。
If the applications for a database consist primarily of transactions that update data, an increase in the number of cleaners will speed up performance.
在数据库应用程序中使用存储过程有许多好处,包括减少对网络的使用、提高性能以及降低开发成本。
There are numerous advantages to using stored procedures for your database applications. Some of the benefits include reduced network usage, improved performance, and reduced development cost.
提高数据库的最大数量可以提高性能,但是需要更多内存。
Increasing the maximum number of databases improves performance but requires more memory.
例如,如果数据库一次只能处理10条消息,那么将JMS监听器最大会话数量从20增加到30将不能提高性能。
For example, if the database can only process 10 messages at time, increasing the JMS listener Max session from 20 to 30 will not improve performance.
在DB 2数据库中使用静态SQL早已被公认为可以提高性能、稳定性和安全性,但是在过去需要专门化的编程才能利用它。
Static SQL against a DB2 database has long been recognized for its ability to improve performance, stability, and security, but has historically required specialized coding to utilize it.
DB 210还包括几个新的数据库设计功能,比如内联大对象(LOB)、散列表访问和RELEASE (DEALLOCATE),这些功能能够提高性能并减少CPU占用。
DB2 10 also includes a number of new database design capabilities, such as inline large objects (LOBs), hash access, and RELEASE (DEALLOCATE), that can improve performance and cut CPU usage.
此外,同时处理多个行还可以提高性能,因为减少了应用程序(DB 2客户机)与数据库引擎之间的交互次数。
Additionally, processing multiple rows together improves the performance because there are fewer round trips between the application (DB2 client) and the database engine.
因此,不必担忧生产数据库将会有多大—为获得高性能而所需的磁盘阵列能够很好地容纳它。
Therefore, there is no need to worry about how large the production database will be — it will fit very well on the disk array that will be needed for performance.
这是IBM进行数据库查询来提高性能的优化努力的结果。
This is a result of the optimization efforts IBM performed to improve the performance of database queries.
为提高性能,最好对应用服务器和ITCAM产品使用不同的数据库。
IT's better to have separate database for the application server and ITCAM products, to gain better performance.
当数据库管理器确定顺序I/O是适当的,并且确定预取操作可能有助于提高性能时,会使用预取操作(通常是大型表扫描)。
Prefetching is used when the Database Manager determines that sequential I/O is appropriate and that prefetching can help to improve performance (typically large table scans).
短数据库事务对任何高性能、高可扩展性的应用程序来说都是必不可少的。
Short database transactions are essential for any highly performing and scalable applications.
除了基础的数据库引擎提升之外,Informix 11.7有几个特性您可以用来进一步提高性能。
Beyond the underlying database engine improvements, Informix 11.7 has several features you can use to further improve performance.
MongoDB是一个可扩展、高性能的下一代数据库。
MongoDB is a scalable, high-performance next-generation database.
应用推荐