# How many records is ON?

**URL:** <https://techcommunity.softwareag.com/t/how-many-records-is-on/80715>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Linux, Natural-Database-Interfaces-on-Open-Systems, Natural-on-Windows-Unix\
**Created:** [April 15, 2009, 12:53am UTC](https://techcommunity.softwareag.com/t/how-many-records-is-on/80715 "2009-04-15T00:53:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [April 15, 2009, 12:53am UTC](https://techcommunity.softwareag.com/t/how-many-records-is-on/80715/1 "2009-04-15T00:53:22Z")

</div>

On a mainframe you specify

```auto
MULTI-FETCH number
```

For Open Systems you specify

```auto
MULTI-FETCH ON
```

To determine the number of records returned by Open Systems, I ran the following

```auto
DEFINE DATA LOCAL
1 EMP VIEW EMPLOYEES
  2 PERSONNEL-ID
  2 NAME
END-DEFINE
*
READ (80) MULTI-FETCH ON EMP BY PERSONNEL-ID
  DISPLAY *COUNTER
          PERSONNEL-ID
          NAME
END-READ
END
```

Via Database Workbench, I see that 10 L3s were executed, so the Multi-fetch factor is 8.

Then I ran similar programs on other machines, with the following results:

```auto
Windows XP 32-bit 8 records
Windows Server 2003 64-bit 32 records
SuSE Linux ES 10 64-bit 8 records
```

This was not an apples-to-apples comparison, because I do not have the EMPLOYEES file loaded on all three machines, but I used very small views (record buffers) in each test.

Can a developer affect the multi-fetch factor in any way (e.g. view size or NATPARMs), or is it an internal constant, dependent soley upon the operating system used?

---

<div class="post-metadata">

**Author:** ![Stephan\_Coslar](https://avatars.discourse-cdn.com/v4/letter/s/ce73a5/32.png) [@Stephan\_Coslar](https://techcommunity.softwareag.com/u/Stephan_Coslar)\
**Post date:** [April 15, 2009, 11:07am UTC](https://techcommunity.softwareag.com/t/how-many-records-is-on/80715/2 "2009-04-15T11:07:10Z")

</div>

Usually and mainly for historical reasons the multi-fetch factor for local Adabas access is 8 and for access via Net-Work is 32.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:51pm UTC](https://techcommunity.softwareag.com/t/how-many-records-is-on/80715/3 "2021-04-02T14:51:48Z")

</div>


