Таблица packetstore (3 247 943 записи, длина строки 2048(кстати ровно страница
).
Произвёл штатную операцию compress, доступную в Informix 11.5.
Таблица похудела на 75% (было 6.4Гб, стало 1.6Гб)
Скорость выполнения набора из 6 select'ов изменилось с 108.6с до 91.2с В среднем на запрос 18.1с и 15.2с (пакет был из 9 запросов - первые 3 там и там отбросил, как разгоночные для кеширования)
время цена результат запрос
00:00:34.250 8039201 5 row(s) retrieved. Select count(*),command from packetstore group by 2;
00:00:30.969 7763889 9 row(s) retrieved. Select count(*),dealstage from packetstore group by 2;
00:00:19.860 7763889 2 row(s) retrieved. Select count(*),inout from packetstore group by 2;
00:00:18.704 8039201 5 row(s) retrieved. Select count(*),command from packetstore group by 2;
00:00:17.578 7763889 9 row(s) retrieved. Select count(*),dealstage from packetstore group by 2;
00:00:17.890 7763889 2 row(s) retrieved. Select count(*),inout from packetstore group by 2;
00:00:18.859 8039201 5 row(s) retrieved. Select count(*),command from packetstore group by 2;
00:00:17.828 7763889 9 row(s) retrieved. Select count(*),dealstage from packetstore group by 2;
00:00:17.703 7763889 2 row(s) retrieved. Select count(*),inout from packetstore group by 2;
00:00:20.312 8039201 5 row(s) retrieved. Select count(*),command from packetstore group by 2;
00:00:15.141 7763889 9 row(s) retrieved. Select count(*),dealstage from packetstore group by 2;
00:00:15.062 7763889 2 row(s) retrieved. Select count(*),inout from packetstore group by 2;
00:00:15.563 8039201 5 row(s) retrieved. Select count(*),command from packetstore group by 2;
00:00:15.016 7763889 9 row(s) retrieved. Select count(*),dealstage from packetstore group by 2;
00:00:15.140 7763889 2 row(s) retrieved. Select count(*),inout from packetstore group by 2;
00:00:15.516 8039201 5 row(s) retrieved. Select count(*),command from packetstore group by 2;
00:00:15.062 7763889 9 row(s) retrieved. Select count(*),dealstage from packetstore group by 2;
00:00:14.984 7763889 2 row(s) retrieved. Select count(*),inout from packetstore group by 2;