🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #386

Re: How to reduce page fault

#386
From: Sascha Wostmann
Date: Tue, 19 May 1998 00:00
29 lines
1414 bytes
Desmond Leung wrote on Mon, 18 May 1998 11:32:42 +0800 :

> I want to know how to count the memory usage of a record?
> How can I find out this information from MDB file?

look into the online-help about data variable declaration (or alike,
search for "integer data type")

Byte            1 Byte
Boolean         2 Bytes
Integer         2 Bytes
Long            4 Bytes
Single          4 Bytes
Double          8 Bytes
Currency        8 Bytes
Date            8 Bytes
Object          4 Bytes
Memo           10 Bytes + Length of Text (10 - ~2,000,000,000)
String(fixed)  Length of Text (1 - ~2,000,000,000)



  Sascha

-- 
s.w@gmx.de
Quote of Today  : 
REALITY.SYS defekt! Universum rebooten (J/n)?
Technical Details
Message-ID: <3561e979.0@news.piro.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <6jh3rs$ecr$1@dover.cityu.edu.hk> <355e0514.0@news.piro.net> <6jlbjf$shc$1@sue.cc.uregina.ca> <6jo9o0$8eo$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/19
Message-ID: <3561e979.0@news.piro.net>
X-Deja-AN: 354728130
References: <6jh3rs$ecr$1@dover.cityu.edu.hk> <355e0514.0@news.piro.net> <6jlbjf$shc$1@sue.cc.uregina.ca> <6jo9o0$8eo$1@dover.cityu.edu.hk>
Organization: home
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access