Re: how to speed up SE and DS

Posted in 1998

Andre Koppel — 11 Dec 1998 22:29:28 GMT — source: Informix-list mailing list archive (1991-1998)

> Talking about Informix SE, (I think it's the same for OnLine), I know that > many indexes slow every INSERTs, UPDATEs and DELETEs (as the indexes have to > be modified too). > The rowsize has a little effect too and any CONSTRAINTs on columns may > generate extra-controls on the entire table. Of course, if you're using > VARCHAR or TEXT data types, it'll slow modifying statements as well. I have not put any constraints on the tables, there is only one index on each table (a serial field), and I have not used varchar, only char(...). -- Andre Koppel Software TCP/IP for QNX 2.x GPIB for QNX4.x at http://www.akso.de and http://www.swd.de