DS_NONPDQ_QUERY_MEM

Posted in 2008

Goldrick, Jim — Thu, 10 Jan 2008 11:49:42 -0600 — source: Usenet: comp.databases.informix

Ok, I have looked and looked and cannot find a decent, somewhat short answer. We just upgraded to HPUX 11.23 and Informix 10.0. I have been looking at tuning presentations, pdf files, etc online for 10.0. I keep seeing reference to DS_NONPDQ_QUERY_MEM to help improve performance for sorts. We are mostly an OLTP, so I have never looked at PDQ. Right now it is set to 768KB. So, I am curious as to how this DS_NONPDQ_QUERY_MEM might improve our performance, if I need to worry about it since we are OLTP, and how, if any, allotting more resources to PDQ might help. We also run an apache server on the same machine and client software for data entry (we're a small university, so data entry for student courses, registration, financials, etc). Thanks much, jim