Click here to Skip to main content
15,929,812 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Thread question Pin
Daniel Lohmann12-Aug-02 12:23
Daniel Lohmann12-Aug-02 12:23 
GeneralRe: Thread question Pin
achandra00712-Aug-02 12:27
achandra00712-Aug-02 12:27 
GeneralRe: Thread question Pin
Wes Jones12-Aug-02 12:05
Wes Jones12-Aug-02 12:05 
GeneralRe: Thread question Pin
achandra00712-Aug-02 12:21
achandra00712-Aug-02 12:21 
GeneralRe: Thread question Pin
Wes Jones12-Aug-02 12:40
Wes Jones12-Aug-02 12:40 
GeneralRe: Thread question Pin
achandra00713-Aug-02 2:52
achandra00713-Aug-02 2:52 
GeneralRe: Thread question Pin
achandra00713-Aug-02 2:58
achandra00713-Aug-02 2:58 
GeneralRe: Thread question Pin
Wes Jones13-Aug-02 5:31
Wes Jones13-Aug-02 5:31 
Hey,

I don't find the ODBC to be slow at all for inserts & updates... I am using more of the ODBC API instead of CDatabase, but that's cause most of my classes work w/ CE (no CDatabase on CE). There are some things you can do to increase performance such as not using CRecordset::AddNew() and then CRecordst::Update to insert a new row. If you know the values, just write an insert statement... it's only one trip to the database instead of two, (unless you need retrieve the new primary key). If you're doing more than a certain # of inserts to the same table(a batch operation let's say), it's best to use a prepared statement & bound parameters at more of an API level than to use a bunch of single insert statements or using AddNew/Update. Just guessing, but i'd think that the odbc classes will be faster than the dao classes.

-Wes


Sonork ID 100.14017 wtheronjones
GeneralRe: Thread question Pin
achandra00713-Aug-02 7:50
achandra00713-Aug-02 7:50 
GeneralMemory dump Pin
Hugo Hallman12-Aug-02 8:09
Hugo Hallman12-Aug-02 8:09 
GeneralRe: Memory dump Pin
PJ Arends12-Aug-02 15:09
professionalPJ Arends12-Aug-02 15:09 
Generalprintf question Pin
Shawn Horton12-Aug-02 8:10
Shawn Horton12-Aug-02 8:10 
GeneralRe: printf question Pin
Tomasz Sowinski12-Aug-02 8:21
Tomasz Sowinski12-Aug-02 8:21 
GeneralRe: printf question Pin
Shawn Horton12-Aug-02 8:39
Shawn Horton12-Aug-02 8:39 
GeneralRe: printf question Pin
Tomasz Sowinski12-Aug-02 8:54
Tomasz Sowinski12-Aug-02 8:54 
GeneralRe: printf question Pin
Shawn Horton12-Aug-02 9:01
Shawn Horton12-Aug-02 9:01 
GeneralRe: printf question Pin
Tomasz Sowinski12-Aug-02 9:09
Tomasz Sowinski12-Aug-02 9:09 
GeneralRe: printf question Pin
Daniel Lohmann12-Aug-02 10:34
Daniel Lohmann12-Aug-02 10:34 
GeneralRe: printf question Pin
Shawn Horton12-Aug-02 10:49
Shawn Horton12-Aug-02 10:49 
GeneralRe: printf question Pin
Daniel Lohmann12-Aug-02 12:28
Daniel Lohmann12-Aug-02 12:28 
GeneralUser breakpoint called from code. Please help! Pin
redeemer12-Aug-02 6:57
redeemer12-Aug-02 6:57 
GeneralRe: User breakpoint called from code. Please help! Pin
Daniel Turini12-Aug-02 7:25
Daniel Turini12-Aug-02 7:25 
GeneralRe: User breakpoint called from code. Please help! Pin
redeemer12-Aug-02 7:34
redeemer12-Aug-02 7:34 
GeneralRe: User breakpoint called from code. Please help! Pin
Daniel Turini12-Aug-02 8:28
Daniel Turini12-Aug-02 8:28 
GeneralRe: User breakpoint called from code. Please help! Pin
redeemer12-Aug-02 9:47
redeemer12-Aug-02 9:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.