Oninit cdi / Archive
Talk to an expert →

query performance SE vs IDS

Posted in 2003

Topics: Performance & Tuning, Server Administration

Jack — — source: Usenet: comp.databases.informix

Hi, i'm looking for arguments to explain why several dbaccess on a single table are 2 times slower with ids than se. i understand this test isn't quite pertinant.The table is organize differently. The sqexplain shows an estimate cost equal to 1. i don't think so it could be less? Thanks for noticing this thread. Jack

↪ replying to Jack
Obnoxio The Clown — — source: Usenet: comp.databases.informix

Jack wrote: > i'm looking for arguments to explain why several dbaccess on a single > table are 2 times slower with ids than se. i understand this test > isn't quite pertinant.The table is organize differently. > The sqexplain shows an estimate cost equal to 1. i don't think so it > could be less? Thanks for noticing this thread. a) What kind of machine, how much RAM, what disks, etc, etc. 2) What do you mean by the table is organised differently? iii) What SQL are you running? D) What versions of SE and IDS? -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche

Glossary