Re: IDS Features - MAX_PDQPRIORITY

Hi DAVID, Thanks a lot for your input I have requested a modification in the documentation. Regarding the last part of your request (HIGH): LOW means 1, HIGH means 100 in IDS. I have requested this to be documented as well. regards Gustavo david@smooth1.co.uk wrote: > On 1 Jan, 01:18, Gustavo Castro <gcast...@bellsouth.net> wrote: > >> Hi, >> >> Did you find this information in an official Informix manual?. If this >> is the case please let us know the name and page in the manual to open a >> documentation defect. Fragment elimination is INDEPENDANT of PDQPRIORITY >> settings. The following small testcase proves this. Notice that >> PDQPRIORITY is set to zero, the selects obviouly skip the fragments that >> do not meet the domain. The text in red shows the elimination of the >> correct fragments >> >> > > Can you please open a different documentation defect?: > > http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.sqlr.doc/sqlr266.htm > > "LOW > Data values are fetched from fragmented tables in parallel." > > further down in the "Using PDQPRIORITY with Dynamic Server" section on > the same page we have > "When you specify LOW, Dynamic Server uses no forms of parallelism.". > > Which is it "Dynamic Server uses no forms of parallelism." or "Data > values are fetched from fragmented tables in parallel."?? > > http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.sqls.doc/sqls838.htm > is clearer - > > "LOW > Data values are fetched from fragmented tables in parallel. (In > Dynamic Server, when you specify LOW, the database server uses no > other forms of parallelism.) " > > and "Value 1 is the same as LOW". > > > I would like more documentation on > http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.sqlr.doc/sqlr266.htm > - > > "When PDQPRIORITY is set to HIGH, Dynamic Server determines an > appropriate value to use for PDQPRIORITY > based on several criteria. These include the number of available > processors, the fragmentation of tables queried, > the complexity of the query, and additional factors." > > It would be nice to get a clear formula for this! > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > >