found speed-Problem

Posted in 1998

Andre Koppel — 13 Dec 1998 23:22:10 GMT — source: Informix-list mailing list archive (1991-1998)

I would like to say thank you for the great amount of E-Mails, that I have received to solve my speed-problem. I have written some code to do some profiling, and I have found a problem within the select-commands. My program searches a column without an index, this drastically reduces the performance. After I have set indices to all the tables at this important column, the performance was greatly improved (more than 200 times). So now, everything works well. Thanks again -- Andre Koppel Software TCP/IP for QNX 2.x GPIB for QNX4.x at http://www.akso.de and http://www.swd.de