Re: Slowness

Thanks for all the posts. I did make some changes and it seems to have sped up quite a bit - my developer was out for a few days, so he'll be the final "judge" - he's the one with the query problems... Also one of our tables got error 136 (extents), so I had to "fix" that problem, so that's why I haven't taken the time to post this additional information.. But here goes. Now this was taken prior to any changes. Thanks again for all the good information. I feel like I've been to a training class!! Robin onstat -F Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days 17:07:49 -- 491520 Kbytes Fg Writes LRU Writes Chunk Writes 47 5706029 67736088 address flusher state data 2504c504 0 I 0 = 0X0 2504c9f0 1 I 0 = 0X0 2504cedc 2 I 0 = 0X0 2504d3c8 3 I 0 = 0X0 states: Exit Idle Chunk Lru onstat -R Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days 17:07:59 -- 491520 Kbytes 4 buffer LRU queue pairs priority levels # f/m pair total % of length LOW MED_LOW MED_HIGH HIGH 0 F 49896 94.9% 47359 0 40878 5302 1179 1 m 5.1% 2537 0 2536 1 0 2 f 49986 95.1% 47517 0 44106 2261 1150 3 m 4.9% 2469 0 2467 2 0 4 f 49985 95.0% 47484 0 44156 2849 479 5 m 5.0% 2501 0 2499 2 0 6 f 49962 95.1% 47501 0 41716 4610 1175 7 m 4.9% 2461 0 2460 1 0 9968 dirty, 199829 queued, 200000 total, 262144 hash buckets, 2048 buffer size start clean at 60% (of pair total) dirty, or 30000 buffs dirty, stop at 50% 0 priority downgrades, 0 priority upgrades onstat -l Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 13 days 17:08:09 -- 491520 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 11 32 6365763 203376 31.30 phybegin physize phypos phyused %used 25b90d 5000 318 235 4.70 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 0 32 2363833 235895 170975 10.0 1.4 Subsystem numrecs Log Space used OLDRSAM 2363833 165659704 address number flags uniqid begin size used %used a8082a4 2 U-B---- 82 200035 5000 5000 100.00 a8082c0 3 U-B---- 83 2013bd 5000 3209 64.18 a8082dc 4 U-B---- 84 202745 5000 639 12.78 a8082f8 5 U-B---- 85 203acd 5000 531 10.62 a808314 6 U-B---- 86 204e55 5000 662 13.24 a808330 7 U-B---- 87 2061dd 5000 638 12.76 a80834c 8 U-B---- 88 207565 5000 545 10.90 a808368 9 U-B---- 89 2088ed 5000 576 11.52 a808384 10 U-B---- 90 209c75 5000 5000 100.00 a8083a0 11 U-B---- 91 20affd 5000 5000 100.00 a8083bc 12 U-B---- 92 20c385 5000 4322 86.44 a8083d8 13 U-B---- 93 20d70d 5000 5000 100.00 a8083f4 14 U-B---- 94 20ea95 5000 5000 100.00 a808410 15 U-B---- 95 20fe1d 5000 5000 100.00 a80842c 16 U-B---- 96 2111a5 5000 2006 40.12 a808448 17 U-B---- 97 21252d 5000 89 1.78 a808464 18 U-B---- 98 2138b5 5000 5000 100.00 a808480 19 U-B---- 99 214c3d 5000 4065 81.30 a80849c 20 U-B---- 100 215fc5 5000 5000 100.00 a8084b8 21 U-B---- 101 21734d 5000 4840 96.80 a8084d4 22 U-B---- 102 2186d5 5000 5000 100.00 a8084f0 23 U-B---- 103 219a5d 5000 4556 91.12 a80850c 24 U-B---- 104 21ade5 5000 5000 100.00 a808528 25 U-B---- 105 21c16d 5000 4490 89.80 a808544 26 U-B---- 106 21d4f5 5000 5000 100.00 a808560 27 U-B---- 107 21e87d 5000 4750 95.00 a80857c 28 U-B---- 108 21fc05 5000 5000 100.00 a808598 29 U-B---- 109 220f8d 5000 5000 100.00 a8085b4 30 U-B---- 110 222315 5000 5000 100.00 a8085d0 31 U-B---- 111 22369d 5000 4052 81.04 a8085ec 32 U-B---- 112 224a25 5000 63 1.26 a808608 33 U-B---- 113 225dad 5000 5000 100.00 a808624 34 U-B---- 114 227135 5000 5000 100.00 a808640 35 U-B---- 115 2284bd 5000 5000 100.00 a80865c 36 U-B---- 116 229845 5000 5000 100.00 a808678 37 U-B---- 117 22abcd 5000 5000 100.00 a808694 38 U-B---- 118 22bf55 5000 1229 24.58 a8086b0 39 U-B---- 119 22d2dd 5000 5000 100.00 a8086cc 40 U-B---- 120 22e665 5000 5000 100.00 a8086e8 41 U-B---- 121 22f9ed 5000 3342 66.84 a808704 42 U-B---- 122 230d75 5000 5000 100.00 a808720 43 U-B---- 123 2320fd 5000 4516 90.32 a80873c 44 U-B---- 124 233485 5000 5000 100.00 a808758 45 U-B---- 125 23480d 5000 4496 89.92 a808774 46 U-B---- 126 235b95 5000 5000 100.00 a808790 47 U-B---- 127 236f1d 5000 4689 93.78 a8087ac 48 U------ 128 2382a5 5000 5000 100.00 a8087c8 49 U------ 129 23962d 5000 5000 100.00 a8087e4 50 U------ 130 23a9b5 5000 5000 100.00 a808800 51 U------ 131 23bd3d 5000 5000 100.00 a80881c 52 U------ 132 23d0c5 5000 5000 100.00 a808838 53 U------ 133 23e44d 5000 5000 100.00 a808854 54 U------ 134 23f7d5 5000 5000 100.00 a808870 55 U------ 135 240b5d 5000 5000 100.00 a80888c 56 U------ 136 241ee5 5000 5000 100.00 a8088a8 57 U------ 137 24326d 5000 5000 100.00 a8088c4 58 U------ 138 2445f5 5000 5000 100.00 a8088e0 59 U------ 139 24597d 5000 5000 100.00 a8088fc 60 U------ 140 246d05 5000 5000 100.00 a808918 61 U------ 141 24808d 5000 5000 100.00 a808934 62 U------ 142 249415 5000 5000 100.00 a808950 63 U---C-L 143 24a79d 5000 1694 33.88 a80896c 64 U-B---- 69 24bb25 5000 5000 100.00 a808988 65 U-B---- 70 24cead 5000 2520 50.40 a8089a4 66 U-B---- 71 24e235 5000