When is read-ahead used? -
11-28-2011
, 07:33 AM
We're testing IDS 11.70.FC3 on RHEL5.7/2.6.18 for a data warehouse
application, and had to turn read-ahead off due to the instance-
crashing bug related to RA. But now the project is reporting that
their ETL routine has doubled in duration. However, release FC4 fixes
the RA bug. Does Informix use read-ahead for inserts? If so, an
upgrade may fix the reported performance problem, too. |