Click here to Skip to main content
15,898,538 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Sending small strings through sockets (lag problem) Pin
gamitech14-Jun-04 9:10
gamitech14-Jun-04 9:10 
GeneralRe: Sending small strings through sockets (lag problem) Pin
kfaday14-Jun-04 9:32
kfaday14-Jun-04 9:32 
QuestionHow to capture "network cable unplugged" event Pin
bikram singh14-Jun-04 7:43
bikram singh14-Jun-04 7:43 
AnswerRe: How to capture "network cable unplugged" event Pin
David Crow14-Jun-04 8:49
David Crow14-Jun-04 8:49 
GeneralRe: How to capture "network cable unplugged" event Pin
bikram singh15-Jun-04 6:37
bikram singh15-Jun-04 6:37 
GeneralNT Windows Service in C++ to call a SQL Server Stored Procedure Pin
Anand Sundaram14-Jun-04 6:56
Anand Sundaram14-Jun-04 6:56 
GeneralRe: NT Windows Service in C++ to call a SQL Server Stored Procedure Pin
Xiangyang Liu 刘向阳14-Jun-04 7:05
Xiangyang Liu 刘向阳14-Jun-04 7:05 
GeneralStored Procedure Concept Pin
Sridhar Sanikommu14-Jun-04 6:44
Sridhar Sanikommu14-Jun-04 6:44 
Hi All,

Need help regarding stored procedure concept using CDatabase & Crecordset database classes. I am working on MFC
application which supports all major RDBMS databases(SQL Server, MySQL, Oracle & MS-Access). I have to process thousands of records from a file and do insert operations.

Right now, this is what I am doing

1. Read one record from a file. Parse it and prepare query.
2. Executing it by using cDatabase's ExecuteSql() function.

But it is taking very long time to process thousand's of records. Every time database has to process the query and prepare an execution plan. That's the reason why I need to solve this problem by using stored procedures which should work with all the databases.

I appreciate if someone could help me in this regard.

Thanks,
Sridhar
GeneralRe: Stored Procedure Concept Pin
David Crow14-Jun-04 8:55
David Crow14-Jun-04 8:55 
GeneralRe: Stored Procedure Concept Pin
Sridhar Sanikommu14-Jun-04 9:15
Sridhar Sanikommu14-Jun-04 9:15 
GeneralRe: Stored Procedure Concept Pin
David Crow14-Jun-04 10:21
David Crow14-Jun-04 10:21 
GeneralRe: Stored Procedure Concept Pin
Sridhar Sanikommu14-Jun-04 10:50
Sridhar Sanikommu14-Jun-04 10:50 
Generaldirect stream copy with AVIFile Pin
Zizilamoroso14-Jun-04 6:32
Zizilamoroso14-Jun-04 6:32 
GeneralI shut down explorer.exe but it restarts itself... Pin
Ian Bowler14-Jun-04 5:50
Ian Bowler14-Jun-04 5:50 
GeneralRe: I shut down explorer.exe but it restarts itself... Pin
toxcct14-Jun-04 6:01
toxcct14-Jun-04 6:01 
GeneralRe: I shut down explorer.exe but it restarts itself... Pin
Ian Bowler14-Jun-04 6:16
Ian Bowler14-Jun-04 6:16 
GeneralRe: I shut down explorer.exe but it restarts itself... Pin
jmkhael14-Jun-04 6:41
jmkhael14-Jun-04 6:41 
GeneralRe: I shut down explorer.exe but it restarts itself... Pin
Ian Bowler14-Jun-04 6:50
Ian Bowler14-Jun-04 6:50 
GeneralRe: I shut down explorer.exe but it restarts itself... Pin
Dan Madden14-Jun-04 9:37
Dan Madden14-Jun-04 9:37 
QuestionHow to show xp toolbar? Pin
JabraJabra14-Jun-04 4:55
JabraJabra14-Jun-04 4:55 
Generallooking for a tool or utility Pin
Anonymous14-Jun-04 4:55
Anonymous14-Jun-04 4:55 
QuestionHow to convert HTML to word DOC? Pin
Tcpip200514-Jun-04 4:31
Tcpip200514-Jun-04 4:31 
AnswerRe: How to convert HTML to word DOC? Pin
vcplusplus14-Jun-04 5:09
vcplusplus14-Jun-04 5:09 
QuestionHow to read all (or cell) data from *.xls? Pin
superwolf100814-Jun-04 4:06
superwolf100814-Jun-04 4:06 
AnswerRe: How to read all (or cell) data from *.xls? Pin
CAmelinckx14-Jun-04 4:33
CAmelinckx14-Jun-04 4:33 

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.