I'm having slow performance with a vb5/sql server 6.5 app. My test
writes 1000 records, with basically the same data in each record. When
using DAO, this test completes in about 25 seconds. When I switched to
ADO, it improved quite a bit, to about 12 seconds. The thing is, if I
use an Access database on the same server (using the JET/DAO engine),
I can write the same number or records in about 3 seconds!
Why is Access so much faster? I thought SQL server was the preferred
"high-end" DB, but if I use it, my app will be much slower.
Any comments appreciated.