Slow Select

We have ported data from SE 7.X to IDS10 via dbimport-tool. There is a table with about a million records. In there is a serial-field (ID) and a numeric field (SYSTEMNR) with a kind of key. On both there is a index. if ask the ids select * from table where ID=4711it takes less than a second select * from table where SYSTEMNR=4711takes about a minute!!! select * from table where SYSTEMNR>4710 and SYSTEMNR<4712it takes less than a second What the hell is this ?????

Did you run an update statistics after dbimport? Joerg Volz ________________________________ Von: ids-bounces@iiug.org im Auftrag von MICHAEL MEIER Gesendet: Fr 18.01.2008 11:05 An: ids@iiug.org Betreff: Slow Select [10977] We have ported data from SE 7.X to IDS10 via dbimport-tool. There is a table with about a million records. In there is a serial-field (ID) and a numeric field (SYSTEMNR) with a kind of key. On both there is a index. if ask the ids select * from table where ID=4711it takes less than a second select * from table where SYSTEMNR=4711takes about a minute!!! select * from table where SYSTEMNR>4710 and SYSTEMNR<4712it takes less than a second What the hell is this ????? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: 07841-681651 Fax: 07841-681654 Mobil: 0170-2989757 Ust-ID: DE201383541 http://www.it-volz.de

Schoenet Ding. That helps. Great. In the end 80's beginning 90's I used more often informix. During this time this was one of standard answers for performance problems. I did`nt thought that this is still important. Thanks a lot

MICHAEL MEIER said: > Schoenet Ding. That helps. Great. > In the end 80's beginning 90's I used more often informix. During this > time > this was one of standard answers for performance problems. I did`nt > thought > that this is still important. It's actually become even more important. -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent." -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

On 18/01/2008, MICHAEL MEIER <freudi_t@yahoo.de> wrote: > Schoenet Ding. That helps. Great. > In the end 80's beginning 90's I used more often informix. During this time > this was one of standard answers for performance problems. I did`nt thought > that this is still important. > > Thanks a lot > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > In my experiance on v7 it was important but not critical, on v9 it was critical but you can get away with quick and dirty lows, on v10 it is critical and you MUST follow the recommendations to the letter !! Keith

On 18/01/2008, Obnoxio The Clown <obnoxio@serendipita.com> wrote: > MICHAEL MEIER said: > > Schoenet Ding. That helps. Great. > > In the end 80's beginning 90's I used more often informix. During this > > time > > this was one of standard answers for performance problems. I did`nt > > thought > > that this is still important. > > It's actually become even more important. > > -- > Bye now, > Obnoxio > > "There were a myriad of problems which conspired to corrupt your reason > and rob you of your common sense. Fear got the best of you, and in your > panic you turned to the Labour Party. They promised you order, they > promised you peace, and all they demanded in return was your silent, > obedient consent." > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > Amen to that !!! Keith