Click here to Skip to main content
15,902,198 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: how to protect files like this? Pin
toxcct8-Jul-05 1:27
toxcct8-Jul-05 1:27 
GeneralRe: how to protect files like this? Pin
khan++8-Jul-05 1:54
khan++8-Jul-05 1:54 
AnswerRe: how to protect files like this? Pin
David Crow8-Jul-05 3:46
David Crow8-Jul-05 3:46 
GeneralCView: Change background color Pin
a_du7-Jul-05 22:12
a_du7-Jul-05 22:12 
GeneralRe: CView: Change background color Pin
khan++7-Jul-05 23:56
khan++7-Jul-05 23:56 
GeneralRe: CView: Change background color Pin
Anonymous10-Jul-05 0:13
Anonymous10-Jul-05 0:13 
GeneralRe: CView: Change background color Pin
TuPacMansur7-Jul-10 13:27
TuPacMansur7-Jul-10 13:27 
GeneralUpsized database 100x slower in SQLServer Pin
mbaker17-Jul-05 21:46
mbaker17-Jul-05 21:46 
I have a Visual C++ Front-end application accessing a MsAccess databases backend via ODBC.

The app uses CRecordset MFC classes to access the db tables.

After upsizing to SQLServer, the process of opening the database and recordsets takes 75seconds as compared with 0.5seconds in Access! I am amazed, and figure something fundamental is wrong.

I use open type of CRecordSet::snaphot in the CRecordset::Open calls. If I use dynaset instead of snapshot it speeds things up a lot, but then I get problems down the line, fundamentally because I don't think the ODBC driver supports dynasets.

I have added clustered index to the primary key of every table in SQL, and this goes a small way to improving performance but not much.

I still think I have missed something fundamental - I am a newbie to SQLServer so go easy! Smile | :)

Many thanks for any help.
Mark
GeneralRe: Upsized database 100x slower in SQLServer Pin
Blake V. Miller8-Jul-05 16:58
Blake V. Miller8-Jul-05 16:58 
GeneralRe: Upsized database 100x slower in SQLServer Pin
Anonymous8-Jul-05 23:12
Anonymous8-Jul-05 23:12 
GeneralRe: Upsized database 100x slower in SQLServer Pin
Blake V. Miller12-Jul-05 17:14
Blake V. Miller12-Jul-05 17:14 
Questionwhich of these is the handle to my windowless app? Pin
awah7-Jul-05 21:45
awah7-Jul-05 21:45 
AnswerRe: which of these is the handle to my windowless app? Pin
khan++7-Jul-05 23:51
khan++7-Jul-05 23:51 
Generalproblem : strtok,strcpy,crashes when garbage strings are handled Pin
awah7-Jul-05 21:37
awah7-Jul-05 21:37 
GeneralRe: problem : strtok,strcpy,crashes when garbage strings are handled Pin
khan++7-Jul-05 23:47
khan++7-Jul-05 23:47 
GeneralRe: problem : strtok,strcpy,crashes when garbage strings are handled Pin
David Crow8-Jul-05 3:52
David Crow8-Jul-05 3:52 
GeneralRe: problem : strtok,strcpy,crashes when garbage strings are handled Pin
John R. Shaw8-Jul-05 9:32
John R. Shaw8-Jul-05 9:32 
Generalmmx help, Privileged instruction exception. Pin
Member 34198917-Jul-05 21:35
Member 34198917-Jul-05 21:35 
GeneralRe: mmx help, Privileged instruction exception. Pin
Member 34198917-Jul-05 22:52
Member 34198917-Jul-05 22:52 
QuestionIs it possible to replace tab buttons in the tab control by a bitmap? Pin
Asha Udupa7-Jul-05 20:48
Asha Udupa7-Jul-05 20:48 
AnswerRe: Is it possible to replace tab buttons in the tab control by a bitmap? Pin
ThatsAlok7-Jul-05 21:38
ThatsAlok7-Jul-05 21:38 
QuestionProblem about Drag in TreeCtrl? Pin
sharkmouse7-Jul-05 19:44
sharkmouse7-Jul-05 19:44 
AnswerRe: Problem about Drag in TreeCtrl? Pin
Nilesh K.7-Jul-05 20:15
Nilesh K.7-Jul-05 20:15 
GeneralUNICODE Pin
John R. Shaw7-Jul-05 17:17
John R. Shaw7-Jul-05 17:17 
GeneralRe: UNICODE Pin
Jose Lamas Rios7-Jul-05 18:09
Jose Lamas Rios7-Jul-05 18:09 

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.