Re: Build a new Informix Server - some questions

From: "Reinhard Habichtsberg" <Reinhard.Habichtsberg@unilux.de> > > >> What can be done force the IDS to spread certain threads to the >available processors?. > > > Que? > >How can I say it in English: For example: your task is to write a >production order >to the database. That causes a series of sql-statements: Write this row, >read that row, >compare next row etc. My impression is that although we have a >multi-processor system >the sequence of sql statements is handled only by one processor. > >I understand that from the logical point of view the SQL's has to be >handled sequencial. >That can all be done by one processor. You understand wrong. >I look for a way to say Informix DBMS to split a certain query and spread >(or should I say "distribute") >it to the available processors. I expect an immense increase of speed if >that could be done. It is. Sub tasks are split across CPU VPs when the engine feels it's relevant. Multiple simultaneous statements will execute on multiple CPU VPs. > >> Is that possible and usable for OLTP or is that a feature (PDQ) only >meaningful with > >> Decision Support Queries. > > > Que? again;) > >This sentence refers to Parallel Data Query (PDQ) which I understand as an >instrument >to distribute queries to more than one processor. The intention of my >question is: >Is PDQ only useable with Decision Support Queries (great number of rows, >sorts etc.) >or is PDQ also applicable in Online Transaction Processing (OLTP) and how >can I >make use of that feature. Do not use PDQ with OLTP -- you will get gated on resources and kill concurrency. > > Forgive me, I'm from Barcelona? > >Really? Nice! No, Barcelona, not Nice. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com