Article View: comp.databases.ms-access
Article #398Re: How to reduce page fault
From: <- Replace with ca
Date: Sun, 17 May 1998 00:00
Date: Sun, 17 May 1998 00:00
22 lines
1594 bytes
1594 bytes
In article <355e0514.0@news.piro.net>, Sascha Wostmann <s.w@gmx.de> wrote: >Desmond Leung wrote on Fri, 15 May 1998 18:09:24 +0800 : >> 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. AFAIK, Access normally stores text null terminated so this won't work. Ie. a 2048 byte record with only "Hi Bob" in it won't be stored as 2K. You may be able to specify this behaviour somewhere, or worst come to worst you'll just have to write your own padding routine. >That doesn't work if you use memo fields, because their length isn't >fixed. Certainly you're right there. -- Jeremy Konopka konopka at cs dot uregina dot ca
Technical Details
Message-ID:
<6jlbjf$shc$1@sue.cc.uregina.ca>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6jh3rs$ecr$1@dover.cityu.edu.hk> <355e0514.0@news.piro.net>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: konopka@cs.uregina.AC (<- Replace with ca) Subject: Re: How to reduce page fault Date: 1998/05/17 Message-ID: <6jlbjf$shc$1@sue.cc.uregina.ca> X-Deja-AN: 353916521 References: <6jh3rs$ecr$1@dover.cityu.edu.hk> <355e0514.0@news.piro.net> Organization: University of Regina, Dept. of Computer Science Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access