Re: Using PDQPRIORITY to throttle certain queries

Sean, a better way to handle this problem would be to start up an SDS secondary server instance (even if you run that on the same machine - assuming you have the memory available for the extra executables and shared memory images) and direct the web site to only query the secondary (unless it is down of course). The SDS secondary will have its own cache memory so that it will have a vastly reduced impact on OLTP performance which will be accessing the memory cache assigned to the primary instance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 4, 2012 at 6:48 PM, Sean Baker <SBaker@moneymailer.com> wrote: > Hoping to get some opinions on this.**** > > ** ** > > We have a public website that is currently using our main production > database (IDS 11.50.FC6). The main query used by the website uses a single > table that typically has 50K to 100K rows. The query typically completes > in 0.4 to 0.5 seconds. We ran some load tests, and if the site gets very > busy, say 20,000 requests per hour, we have some noticeable performance > degradation in the production system (mainly an OLTP system, order entry, > reporting, menu response, etc.).**** > > ** ** > > I’m not very familiar with PDQ, but a colleague suggested we could use > PDQPRIORITY to “throttle” the requests coming from the website. These are > certainly not DSS queries, so it seems to me that PDQ is not really > intended for that.**** > > ** ** > > Is “throttling” certain db queries a common use of PDQ?**** > > ** ** > > Thanks,**** > > ** ** > > Sean.**** > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >