![]() I think it is due to server-side cursors, but I didn't find a way to disable them. However, with the MSSQL Native Client, things slow down, because on every MoveNext(), the driver communicates with the server. The query is returned, and everything is lightning fast. Now, with the MySQL driver, everything runs as it should. R.Open(CRecordset::snapshot, L"SELECT a.something, b.sthelse FROM TableA AS a LEFT JOIN TableB AS b ON a.ID=b.Ref") Ĭrs.GetFieldValue(L"a.something", strData) The MySQL ODBC driver does not exhibit this nasty behavior. Now, when we use MSSQL (with the Native Client 10.0), retrieving records with SELECT is dramatically slow via slow links (VPN, for example). We have an application that uses ODBC via CDatabase/CRecordset in MFC (VS2010).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |