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-------------------------------
| Вернуться в корень Архива
|