RE: buffer size

Posted in 1999

Buchholz, David — Wed, 16 Jun 1999 17:31:22 -0400 — source: Informix-list mailing list archive (1991-1998)

Welcome Garry!! Given the 2K pagesize for your system, your transfer buffers are sized at 63,988 bytes ( (BAR_XFER_BUF_SIZE * PAGESIZE) + 500 = 63988 ). The extra 500 is for overhead. This number is just fine since XBSA has a 64K limit for transfer buffers anyway. HTH. -Dave David A. Buchholz Senior Database Administrator Cendant Incorporated david.buchholz@hit.cendant.com Voice: 602.220.5853 Fax: 602.220.5877 -----Original Message----- From: Taylor, Garry [mailto:garry.taylor@rez.com] Sent: Wednesday, June 16, 1999 12:17 PM To: 'informix-list@iiug.org' Subject: buffer size Hello everyone, I just joined the group this morning and here with my first question. OS sun 2.5 running on a E10000 Informix ver 7.23uc2 Question what is the recommended buffer size for onbar? Right now I have BAR_XFER_BUF_SIZE 31 Garry Taylor Operations Analyst Unix Systems Email garry.taylor@rez.com 602-735-7220 page 709-1816