Performance problems moving from ODBC dBase DSN to ODBC SqlServer DSN. -- sql server odbc

CharlesC
7/19/2007 2:20:57 PM

Hello,

I imported dbf files (dbase) into an msde database.

I see the tables with the data in the msde database. The data is identical.

The only change made to the code is in the DSN assignment in the Recordset's
GetDefaultConnect(),
return _T("ODBC;DSN=themsde").

Both DSN's are ODBC, the original uses Microsoft dBase driver (dbf),
the msde is of course SQL Server.

Using the SAME data and the SAME code I add a record (AddNew())
the Recordset.Open() takes about 4 or 5 times longer with the msde dsn
the Recordset.Update() takes about 10 times longer (eg. 10 seconds with the
msde dsn, less than 1 with dbase odbc dsn)

Are there changes that have to be made in the code or in the data?

Thanks.

CharlesC
9/20/2007 12:00:00 AM

Differences between odbc dbase and sql required adjustments to table design
and filters.
Thanks anyway.

[quoted text, click to view]

sql server odbc : Performance problems moving from ODBC dBase DSN to ODBC SqlServer DSN.