为了优化性能，每个活动数据库服务器任务应该有10MB内存。
For optimal performance, there should be 10mb of memory per active database server job.
任务包括计划并管理数据库、调优性能与容量、创建和维护索引并优化查询、监测、以及管理备份与恢复。
Tasks include planning and administering the database, tuning for performance and capacity, creating and maintaining indexes and optimizing queries, monitoring, and managing backup and recovery.
数据库配置设置和变量也可能需要进行优化以实现最佳性能。
Database configuration Settings and variables might also need to be optimized for maximum performance.
然而进程跳跃到数据库的成本依然很高，因此数据层的性能是您在优化代码时首先要考虑的问题。
However, the cost of process hopping to the database is still high, thus performance on the data tier is the first place to look when optimizing your code.
这使得数据库系统管理员可以优化没有使用更新语句处的性能，或使用更新语句时也可以防止死锁。
This allows the database administrator to optimize the performance where the update syntax is not used, or to prevent deadlocks when it is used.
您可能对更改其中某些统计值来影响优化器、或者在开发或测试环境中调查研究数据库性能感兴趣。
You might be interested in changing some of these statistical values to influence the optimizer or to investigate database performance in a development or test environment.
选择适当的分区键对于优化基于DB 2软件的分区环境中的数据库性能非常关键。
Choosing appropriate partitioning keys is essential for optimizing database performance in a partitioned environment based on DB2 software.
在当今的经济环境中，数据库性能和成本优化的重要性和价值怎么强调也不过分。
In the current economic climate, the immediate need for and value of database performance cost optimization and tuning cannot be overstated.
最后，您将了解如何对查询进行分析以优化数据库的性能。
Finally, you'll see how you can profile your queries to optimize the performance of your database.
这是IBM进行数据库查询来提高性能的优化努力的结果。
This is a result of the optimization efforts IBM performed to improve the performance of database queries.
它可随数据库进行扩展，并且特定于XML的优化使得它具有比CLOB更好的性能。
It scales with the database, and XML-specific optimizations give it better performance than CLOBs.
因此，为了实现最佳性能的高级SIEM解决方案，您应该考虑一些优化特定环境数据库的具体DB 2参数。
Therefore, to give you the best possible performance of an advanced SIEM solution, you should consider specific DB2 parameters to fine-tune the database for your specific environment.
要优化Monitor性能，您通常需要配置Monitor和消息引擎数据库。
To optimize Monitor performance, you usually need to configure the Monitor and the message engine databases.
所推荐的操作实践阐明了如何优化Web服务器、应用服务器、LDAP服务器和数据库服务器的性能。
The recommended practices illustrate how to optimize the performance of the Web server, application server, LDAP server, and database server.
Netezza系统采用了先进的硬件技术，同时仔细研究了如何在针对专门目的构建和优化的环境中最大化数据库性能。
The Netezza system combines advanced hardware technology with careful study of how to maximize database performance in a purpose-built and optimized environment.
Optim PerformanceManager有助于优化业务关键型DB 2数据库和应用程序的性能和可用性。
Optim performance Manager helps optimize the performance and availability of business-critical DB2 databases and applications.
许多Informix新客户没有认识到他们必须更新统计数据，因此由于缺少最新的优化器统计数据，他们的数据库性能很差。
Many customers new to Informix do not realize they must update statistics, and see poor performance due to the lack of optimizer statistics.
在通常的情况下，文档的数据来源可能是外部(比如数据库，文件系统，蜘蛛从网站上的抓取等)，这些通常都比较耗时，尽量优化获取它们的性能。
Speed up document construction. Often the process of retrieving a document from somewhere external (database, filesystem, crawled from a Web site, etc.) is very time consuming.
XML数据库还使用其他大量的技巧来优化性能。
XML databases use a lot of other tricks to optimize performance.
为了确保最优的数据库性能，需要确保数据库得到了全部的优化。
To ensure optimal database performance, it is necessary to ensure that the database is fully optimized.
CHAR数据类型有助于性能提高，因为数据库确切地知道每个char列有多大，所以在读写数据时就可以执行某种性能优化。
The CHAR data type provides a performance boost because the database knows exactly how big every CHAR column will be and can make certain performance optimizations when reading or writing the data.
PHP4包含十多个不同的专用数据库扩展，针对特定的数据库功能和性能进行优化。
PHP 4 contains more than a dozen different database-specific extensions optimized for a particular database's functionality and performance.
最优数据库性能还需要数据库优化器很好地发挥作用。
Optimal database performance requires the database optimizer to do its job well.
同样地，应用程序设计也能调优性能：更少的对象创建、实时的数据库优化以及使用数据库连接池。
Similarly the application design can be tuned for performance: Fewer object creations, ongoing database refinements, and using database connection pooling.
因此，基于数据库系统的性能调整与优化对于整个系统的正常运行起着至关重要的作用。
Therefore, the database system performance tuning and optimization, involving multi-layers, are vital for the whole system to be in normal operation.
由于Derby数据库针对SQL查询做了优化，因此访问资源索引时可获得最佳性能。
Because the Derby database is optimized for SQL queries, you get optimal performance when accessing the resources index.
那些熟悉systemi和数据库查询性能分析和调优的人就会理解控制优化目标是优化性能的关键步骤。
Those familiar with System I and database query performance analysis and tuning, understand that controlling the optimization goal is a critical step to optimizing performance.
而且，Hibernate将此设置用作针对某些数据库类型的数据库提示从而优化查询性能。
Moreover, Hibernate USES this setting as a database hint against certain database types for optimized query performance.
在DB 2中，性能优化主要针对大型数据库，如SAPBusinessInformationWarehouse (BIW)；而SQL优化的目标则是为了缩短查询时间。
In DB2, performance optimization is targeted to large databases, such as SAP Business Information Warehouse (BIW), while SQL optimization aims to improve query times.
最后，对SQLSERVER数据库性能调整与优化问题进行了总结和展望。
Finally, a summary and prospect on the problems of SQL SERVER database performance tuning and optimization are made in this paper.
应用推荐