PDQPRIORITY

Hi, We are facing a lot of performance problem in informix 7.3 Application was running fine till we moved from 7.2 to 7.3. Someone suggested set pdqpriority to 100. The application is written in esqlc. The maxpdqpriority is set to 100 in the server. I've set the pdqpriority to 100 in the application by EXEC SQL prepare d_id from "set PDQPRIORITY 100" ; EXEC SQL execute d_id; But when I execute the application, I get the error saying ERROR MESSAGE: Cannot support multiple connections over shared memory. How should I set the pdqpriority in the esqlc program ???? Pl. help me out ... Thanks krishnakumar Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

Try running update statistics for all your tables. Also, look in the manual and follow their advice for any columns that head or are a part of an index. This will work wonders. krishnakn@my-deja.com wrote in message <7nansr$vt9$1@nnrp1.deja.com>... > > >Hi, > >We are facing a lot of performance problem in informix 7.3 >Application was running fine till we moved from 7.2 to 7.3. > >Someone suggested set pdqpriority to 100. > >The application is written in esqlc. >The maxpdqpriority is set to 100 in the server. > >I've set the pdqpriority to 100 in the application by > EXEC SQL prepare d_id from "set PDQPRIORITY 100" ; > EXEC SQL execute d_id; > >But when I execute the application, I get the error saying > >ERROR MESSAGE: Cannot support multiple connections over shared memory. > >How should I set the pdqpriority in the esqlc program ???? > >Pl. help me out ... > >Thanks >krishnakumar > > >Sent via Deja.com http://www.deja.com/ >Share what you know. Learn what you don't.