Gregory S. Williamson wrote: > On Informix however it is blindingly fast, and can also be instantly > conjured with the dbaccess tool (Info/Table/Status). They might be > stashing this count somewhere, but it is not available when the table > is locked, as during a load. However they do it, performance does not > seem to suffer, and having this rapidly available is certainly nice. > Especially when people are used to it. > Informix locks rows during modification so they don't have the MVCC visibility problem we have (some rows are visible to only some backends). -- Bruce Momjian | http://candle.pha.pa.us pgman@xxxxxxxxxxxxxxxx | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
