清单4：创建会话表的sql。
清单4给出了创建会话表的SQL代码。
Listing 4 shows the SQL code that created the sessions table.
我们测试过这种方法，在大会话表中显示了10- 15%的性能提升。
We've benchmarked this approach and it shows 10-15% performance gain on large sessions tables.
在应用程序会话定义已创建的临时表之后，并发运行的会话不需要重新定义它。
After an application session defines a created temporary table, concurrently running sessions do not have to redefine it.
您还可以根据系统需求在不同的级别灵活配置，包括实例、会话和表。
You also have the flexibility to configure Settings at all levels, including instance, session and table, based on the needs of your system.
从本质上说，CGTT将表设置流程移到了会话外部。
CGTT essentially moves the table setup process outside the session.
当表非常大或者大量会话发出这种类型的查询时，性能将会有所下降。
Performance is negatively impacted when the table is large or when many sessions issue this type of query.
创建cgtt表cgttbase1之后，它将持久化到后续所有的会话中。
Once CGTT table cgttbase1 is created, it is persistent to all sessions that follow.
您需要将ActionURL存储到会话的例子是Ajax驱动的分页数据表，它包含ActionURL链接作为数据集的一部分。
An example of when you would want to store Action URLs into the session is an Ajax-driven paging data table that contains Action URL links as part of the data set.
如果这些字符串相匹配，通过logger函数把这个事件记录在另一个mysql表中作为日志，并且生成一个新的会话id。
If these strings match, this event is logged to another MySQL table via the logger function and a new session ID is generated.
IDENTITY返回当前会话的，所有作用域中的任何表最后一个生成的IDENTITY值。
Identity returns the last identity value generated for any table in the current session, across all scopes.
这种行为的一个影响是，即使当前用户没有创建它们的权限，会话也可以操纵它的临时表。
One implication of this behavior is that a session can manipulate its temporary tables even if the current user has no privilege to create them.
表2标出了4个类，分别对应于4种会话作用域。
Table 2 identifies the four class types that correspond to the four session scopes.
表1总结了三类Web服务api定义，包括会话、变更历史和查找操作。
Table 1 summarizes the three types of Web service API definitions, including session, change history and find operations.
为更新subscribedfeeds表，我们需要知道登录用户的username，所以我们要从会话中获取该信息。
To update the subscribedfeeds table, you need to know the username for the logged-in user, so you grab that from the session.
它还可用于长时间的会话锁，但需要进行清理以避免表过度增长。
It can also be used for longer-lived session locks, but cleanup needs to be addressed to prevent table growth.
对于这个报告，你需要显示每个用户当前的内存使用情况图，然后在一个表中按照每个会话将内存使用划分。
For this report, you want to display a graph of total memory usage per user and then, in a table, break that memory usage down on a per-session basis.
您可以使用PASSTHRU会话直接将CREATEtable语句发送到数据源，并为这个新表创建一个昵称。
You can use the PASSTHRU session to directly send the create table statement to the data source and create a nickname for this new table.
糟糕的数据库性能，因为数据库对数据库表中的该(超)大会话对象执行了数百次更新。
Poor database performance, as the database performed hundreds of updates to the (very) large session objects in database tables.
OpenTables：此会话中打开的表数。
Open tables: Displays the number of the tables opened in that session.
图14中的值指定两个进程使用两个会话将数据加载到数据库表中。
The values shown in Figure 14 specify that two processes use two sessions to load data into the database table.
这两种情况下，若在相同会话中企图重新声明临时表将导致如下错误。
In both cases, attempts to re-declare a temporary table within the same session will result in the following error.
在会话中，试着同时更新department表中的位置数据和部门名称。
In the sessions, try to update location data and department names in the table department in parallel.
相反地，应该使用内存中的哈希表来缓存数据，并且在会话中保存一个对此数据进行引用的键。
Instead, use an in memory hash table to cache the data and just keep a key to the data in the session.
创建一个db2表(在下文中称为锁表(locktable))，它定义与会话锁定相关的资源。
Create a DB2 table (hereafter referred to as lock table) to define the resources related to session locking.
格赖斯在1975年发表的著作“逻辑与会话”一文中提到会话含义的一类——一般会话含义和特殊会话含义。
Grice referred to a branch of conversational implicature - the generalized conversational implicature and the particularized conversational implicature in "Logic and conversation" published in 1975.
清单1给出这个交互式会话，表2详细解释此会话。
Listing 1 shows this interactive session, and Table 2 explains the session in detail.
要在第二个会话中使用dgttbase1，您需要在会话中重新创建表。
To use dgttbase1 in the second session, you have to recreate the table in the session again.
当在会话中设置STATCHANGE后，它将影响该会话中在其上运行updatestatistics的表。
When STATCHANGE is set in a session, it affects the tables on which update statistics is run in that session.
当在会话中设置STATCHANGE后，它将影响该会话中在其上运行updatestatistics的表。
When STATCHANGE is set in a session, it affects the tables on which update statistics is run in that session.
应用推荐