Storing performance in DAO

Kjell Gunnar Tenstad -- kjellg@albatross.no
Wednesday, January 31, 1996

I'm planning to use  VC 4.0 and the DAO classes to store
fast arriving real-time date into an Access database. The
records are very simple (ID, time, status and value).
A year or so ago I tested adding records to the same table using Access basic inside MS-Access1.1:
Utilising BeginTrans/ CommitTrans
=====> 1500 records in 2 sec, i.e. 750 rec./sec
=====> 10000 records in 15 sec, i.e. 666 rec./sec
(measured on my old 486/66)

Can I expect similar or better performance through DAO ??.
Comments welcome from everybody with DAO experiences!!.


--
------------------------------oO00Oo-------------------------------
kjellg@albatross.no     Kjell Gunnar Tenstad,  Tel.+(47)32865000
                                               FAX.+(47)32735825
BMW R 60 ----------------------1960-------------------- BMW R 26 
------------------------------oO00Oo-------------------------------

---

Darren Martz -- martz%mspo3@mprgate.mpr.ca
Thursday, February 01, 1996


I have been using the new 32 bit Jet (v3.0) and have seen a large   
increase in performance over old 16 bit Jet (1.1).

The MFC 4.0 implementation uses the DAO 3.0 COM interfaces rather than   
the old ODBC solution of having an ODBC driver to talk to DAO to talk to   
Jet. As for transactions, my experience is with Sybase and SQLServer so   
this information is based on simpler Jet uses, but I hope it helps none   
the less.

Darren

 ----------
From:  owner-mfc-l[SMTP:owner-mfc-l@netcom.com]
Sent:  Wednesday, January 31, 1996 12:00 AM
To:  mfc-l
Subject:  Storing performance in  DAO

I'm planning to use  VC 4.0 and the DAO classes to store
fast arriving real-time date into an Access database. The
records are very simple (ID, time, status and value).
A year or so ago I tested adding records to the same table using Access   
basic
inside MS-Access1.1:
Utilising BeginTrans/ CommitTrans
=====> 1500 records in 2 sec, i.e. 750 rec./sec
=====> 10000 records in 15 sec, i.e. 666 rec./sec
(measured on my old 486/66)

Can I expect similar or better performance through DAO ??.
Comments welcome from everybody with DAO experiences!!.


 --
 ------------------------------oO00Oo-------------------------------
kjellg@albatross.no     Kjell Gunnar Tenstad,  Tel.+(47)32865000
                                               FAX.+(47)32735825
BMW R 60 ----------------------1960-------------------- BMW R 26
 ------------------------------oO00Oo-------------------------------

---

| Вернуться в корень Архива |