Re: PDQPRIORITY

I agree that update statistics would help you. And definitely you should perform it. Some additions about the error message: If you are using more than one connection to database server, you have to use tlitcp connections (you can't use shared memory connections). So, you have to add an alias to your database server in your $ONCONFIG file and an entry for this server alias in your sqlhosts file. This entry should have as protocol a tcp or stream (not shared memory) connection (i.e. onsoctcp or ontlitcp). See your server release notes for supported connection types. Then you just have to set the INFORMIXSERVER env. variable accordingly. Best Regards, Octav On Fri, Jul 23, 1999 at 06:07:31PM -0700, Richard Auslander wrote: > I want to agree strongly with Krishna - PDQPRIORITY 100 can and does help, but > it can NEVER solve serious performance problems, since it may give you another > 30% or so, but only at the expense of other concurrent processes. I can almost > guarantee you that either some needed indexes are missing, or that the query > optimizer is failing to use a needed index and is instead performing a serial > table scan. Since the query optimizer bases its plan on the distribution > statistics, performing an update statistics as described in the Informix tuning > manual can often make a dramatic performance improvement. If you can, compare > the optimizer's query plan on the 7.2 database to that of the 7.3 database - > most likely, you will see significant differences. > > News wrote: > > > 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. > > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com > -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com