.mdb size and adCmdTable vs adCmdTableDirect

  • Thread starter Thread starter John Doehead
  • Start date Start date
J

John Doehead

Good day.

I have 2 questions:

1) I have a very simple database with a single table containing a long
integer, single, and memo field. When this table is empty the DB size is
say 'x'. If I add one record and fill in the long integer, single, and memo
fields, it grows by 2K. If I add another, it remains the same size (x+2K).
Now, I realize it has pre-allocated some space, but where can I get
information on database growth relating to record addition? Put another
way, where can I find information on how size is allocated in general for a
..mdb file?

2) What exactly is the difference between adCmdTable and adCmdTableDirect?
I have read the help and it sounds as though adCmdTableDirect does not use
ADO, but rather gets the provider to do the work. In either case, a
recordset is returned, so it is simply a matter of what (ADO vs the
provider) builds it, correct? Is there a rule of thumb that should be used
(i.e. when should the provider be used vs using ADO)? Is using the provider
faster since it removes one level of (the ADO) processing?


Thanks in advance for any help you can provide.
Cheers.
Hound.
 
Back
Top