buffwaits
Is there any way to tune buffwaits?
Alcea Technologies is one of Ottawa's fastest expanding IT consulting companies due to their outstanding client/consultant relationships. One of our clients is offering a contractual position for a C/Informix Developer . The client is a private sector organization in the National Capital Region. This is an immediate long-term contract position to start with an option to go permanent. The position requires: - experience with C programming/Development - experience with Informix databases For more information regarding this opportunity, please contact me directly. Alcea Technologies Inc. is an Ottawa based IT consulting company, who opened their doors in April 1997. Our strengths are varied and cover numerous technical fields, including relational technologies such as Oracle, Informix and Sybase experience along with software development. We pride ourselves in having a strong selection of quality consultants whom operate under an open and honest relationship with the company. They have full access to the contracts and a clear mandate on what the client's expectations are when they go into a respective site. -- Charlene S. Hosein Marketing Executive Alcea Technologies Inc. IT Contract and Consulting Firm Ottawa, Canada (613) 563-9595 (613) 563-9494 Fax chosein@alceatech.com http://www.alceatech.com/ ** Please submit resumes via our online system
Alcea Technologies is one of Ottawa's fastest expanding IT consulting companies due to their outstanding client/consultant relationships. One of our clients is offering a contractual position for a Junior/Intermediate 4GL Programmer. The client is a private sector organization in the National Capital Region. This is an immediate long-term contract position. Any experience/training with Informix 4GL will be considered. For more information regarding this opportunity, please contact me directly. Alcea Technologies Inc. is an Ottawa based IT consulting company, who opened their doors in April 1997. Our strengths are varied and cover numerous technical fields, including relational technologies such as Oracle, Informix and Sybase experience along with software development. We pride ourselves in having a strong selection of quality consultants whom operate under an open and honest relationship with the company. They have full access to the contracts and a clear mandate on what the client's expectations are when they go into a respective site. -- Charlene S. Hosein Marketing Executive Alcea Technologies Inc. IT Contract and Consulting Firm Ottawa, Canada (613) 563-9595 (613) 563-9494 Fax chosein@alceatech.com http://www.alceatech.com/ ** Please submit resumes via our online system
In article <7oj056$6g6u$1@newssvr04-int.news.prodigy.com>, "Dhanesh Kottile Veedu" <KVDHANESH@prodigy.net> wrote: > Is there any way to tune buffwaits? > > Yes, of course. First of all, you have to look at your LRUs. Generally speaking, LRUS=4*NUMCPUVPS is sometimes too low. I think, you need 1 LRU pair per 500 buffers up to 128 possible. Also, remember that values like 64 or 96 degrades performance - don't set LRUs to this values. If increasing LRUs don't give you desirable effect - than you need to rewrite something in your application. For example- query A updates data,and locks the buffer in memory.If at the same time query B needs this buffer too - this time buffwaits increases. I think the way to avoid this situation is to change something in your application. Hope, this helps. -- With best regards, Yuri Dovgart, SAP R/3, Informix consultant, "Telecominvest" company. E-mail y_dovgart@tci.ukrtel.net Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.