For some queries, IWA does not improve performance.
对于某些查询，IWA并没有提高其性能。
Based on my testing, one-hour queries run in two to three minutes with IWA.
根据我的测试，使用了IWA后，为时一小时的查询只需要三分钟即可完成。
Your applications do not need to change or be recompiled to benefit from the speed of IWA.
您的应用程序不需要进行修改或重新编译，就能直接受益于 IWA 的速度。
In fact, I see IWA replacing the need for many of the summary tables I design in a data warehouse.
事实上，我们已经看到，IWA取代了我在数据仓库中设计的汇总表中的许多需求。
IWA does not handle all types of queries yet, such as correlated sub-queries or queries using temp tables.
IWA还无法处理所有类型的查询，比如关联子查询或使用临时表的查询。
Running this query without IWA on Informix took more than an hour to read, gather, sort, and sum all the data.
在没有结合使用IWA技术的情况下，在Informix上运行此项查询要花费1个多小时的时间来读取、收集、分类和合计这些数据。
Running this query with IWA took nine minutes, and we were able to reduce the size of the Informix memory buffers.
在结合IWA技术的情况下运行此项查询只需花费9分钟时间，我们可以减少Informix内存缓冲。
When an application sends a query to Informix, the Informix optimizer decides whether the query should be sent to IWA.
当应用程序向Informix发送一个查询，Informix优化器会决定是否应该将此查询发送至IWA。
The workshop will take place 09:00-17:30, 7 September and is co-convened with the International Water Association (IWA).
该研讨班将于9月7日09:00-17:30与国际水协会共同举办。
But since the temp tables had not been defined and realized in IWA, Informix handled the second query as a normal query.
但是，由于在IWA中无法定义和实现临时表，所以Informix像处理普通查询一样处理第二次查询。
As the chart in Table 1 shows, most queries that returned nine or fewer records and can use an index are faster without IWA.
正如表1图表所示，大多数查询只返回9条及更少的记录，如果不使用IWA而是使用索引的话，速度可能更快。
When the Informix server gets the data back from IWA, it returns the results to your application-only much faster than before (Figure 1).
当Informix服务器收到从IWA返回的数据，会将结果返回给您的应用程序，速度比之前快很多(图1)。
IWA technology loads the records from a data warehouse star schema into memory in a compressed format, and organizes the data using new columnar storage technology.
IWA技术以压缩格式将数据仓库星型架构中的记录载入内存，并使用新的列存储技术来组织数据。
IWA is an exciting breakthrough-combining new data warehouse technology with traditional Informix relational database servers-that results in very fast performance.
IWA是一个令人振奋的突破，它将新的数据仓库技术和传统的Informix关系数据库服务器相结合，产生一种非常快的性能。
Any query that cannot be optimized by IWA is optimized and handled by Informix without users even knowing it, except that they will notice the slower response time.
Informix可以在用户无法察觉(除了因为响应时间较慢而通知用户)的情况下优化和处理IWA无法优化的任何查询。
A database must be designed using a dimensional model star schema to work with IWA, and the tables must be defined and loaded into IWA to take advantage of its performance.
设计数据库时必须将维度模式星型架构与IWA相结合，必须定义表格并将它们载入IWA中，以充分利用IWA的性能。
A database must be designed using a dimensional model star schema to work with IWA, and the tables must be defined and loaded into IWA to take advantage of its performance.
设计数据库时必须将维度模式星型架构与IWA相结合，必须定义表格并将它们载入IWA中，以充分利用IWA的性能。
应用推荐