Performance problems moving from ODBC dBase DSN to ODBC SqlServer DSN.

Performance problems moving from ODBC dBase DSN to ODBC SqlServer DSN.

Post by Charles » Sat, 21 Jul 2007 03:20:57


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.
 
 
 

Performance problems moving from ODBC dBase DSN to ODBC SqlServer DSN.

Post by Charles » Fri, 21 Sep 2007 21:50:54

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



identical.
Recordset's
the