Re: How to reduce page fault

Article View: comp.databases.ms-access

Article #396

Back to comp.databases.ms-access Previous Next

#396

From: Sascha Wostmann
Date: Sat, 16 May 1998 00:00

23 lines
1159 bytes

Desmond Leung wrote on Fri, 15 May 1998 18:09:24 +0800 :

> Hi,
> 
> Does any one know how to pack an record to
> the same length as Microsoft jet database engine
> default memory page(2K) to enhance concurrency
> and preformance.

just calculate the memory useage of your current records and add
another (text)field as long as the difference to the next 2k barrier.

That doesn't work if you use memo fields, because their length isn't
fixed.


  Sascha

-- 
s.w@gmx.de
Quote of Today  : 
Tastatur nicht gefunden. Druecke F1 zum Fortfahren

Technical Details

Message-ID: <355e0514.0@news.piro.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6jh3rs$ecr$1@dover.cityu.edu.hk>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111a5a,f0f2f7b5feee8544
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,f0f2f7b5feee8544
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 102b1d,f0f2f7b5feee8544
X-Google-Attributes: gid102b1d,public
From: s.w@gmx.de (Sascha Wostmann)
Subject: Re: How to reduce page fault
Date: 1998/05/16
Message-ID: <355e0514.0@news.piro.net>
X-Deja-AN: 353882760
References: <6jh3rs$ecr$1@dover.cityu.edu.hk>
Organization: home
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access

Reply to Parent Message