|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
how does a recordset work ?My memory capacity is 384 MB and I have opened a DAO recordset that is larger than the capacity successfully. It has 900000 records. Each record contains 1000 characters. Though I have opend it successfully, but I still do not know how it works. Does it work using "disk cache" ? How many MBs of memory have been occupied by my recordset ? Could you help me ? Thanks in advance John S *** Sent via Developersdex http://www.developersdex.com *** "John S" <nospam> wrote in message Seems pretty limited for a person... <g>news:us8NrFrVHHA.5060@TK2MSFTNGP06.phx.gbl > Hello All, > > My memory capacity is 384 MB > and I have opened Yes> a DAO recordset that is larger than the > capacity successfully. It has 900000 records. > Each record contains 1000 characters. > Though I have opend it successfully, but I still > do not know how it works. Does it work using > "disk cache" ? > How many MBs of memory have been that will probably vary depending on what else is going on; does it matter?> occupied by my recordset ? -- Reply to the group so all can participate VB.Net: "Fool me once..." Also keep in mind that typically, a recordset won't be held all in memory at
once. It might be, but usually not. Usually only a few rows are held in memory at a time...how many depends on various settings, but I believe in DAO, the default is 100 (someone feel free to correct me if I'm mistaken). Rob Show quoteHide quote "Bob Butler" <tiredofit@nospam.ever> wrote in message news:OMIO4KrVHHA.4632@TK2MSFTNGP04.phx.gbl... > "John S" <nospam> wrote in message > news:us8NrFrVHHA.5060@TK2MSFTNGP06.phx.gbl >> Hello All, >> >> My memory capacity is 384 MB > > Seems pretty limited for a person... <g> > >> and I have opened >> a DAO recordset that is larger than the >> capacity successfully. It has 900000 records. >> Each record contains 1000 characters. >> Though I have opend it successfully, but I still >> do not know how it works. Does it work using >> "disk cache" ? > > Yes > >> How many MBs of memory have been >> occupied by my recordset ? > > that will probably vary depending on what else is going on; does it > matter? > > -- > Reply to the group so all can participate > VB.Net: "Fool me once..." > "Bob Butler" <tiredofit@nospam.ever> wrote in message That's not really true (in all cases at least). It will read information news:OMIO4KrVHHA.4632@TK2MSFTNGP04.phx.gbl... >> and I have opened >> a DAO recordset that is larger than the >> capacity successfully. It has 900000 records. >> Each record contains 1000 characters. >> Though I have opend it successfully, but I still >> do not know how it works. Does it work using >> "disk cache" ? > > Yes from the disk as needed which is different to a disk cache. Michael "John S" <nospam> wrote in message Likely very little.news:us8NrFrVHHA.5060@TK2MSFTNGP06.phx.gbl... > "disk cache" ? How many MBs of memory have been > occupied by my recordset ? Michael 
Other interesting topics
|
|||||||||||||||||||||||
