|
hi
This is Apoorva raje.I am facing a problem with SqlExecuteDirect() function, my piece of code is doing deleting all the recods from 12 different table and then insert new records in those tables. each table will have approximate 100 to 1,00,000 records .For deletion i copy the query into a char array and then first allocate a statement handle execute it by SqlExecuteDirect()function and then free the statement handle but even we are freeing the statement handle the memory is not freed and its accumulating around 12mb. the code is given below:
//delete ARCDataSet //Same code for deleting data for 12 other tables
rc = SQLAllocHandle(SQL_HANDLE_STMT,ConHandle,&StmtHandle);
memset(szSQL,0,1024);
sprintf(szSQL,"delete from ARCDataSet");
rc = SQLExecDirect(StmtHandle,(SQLCHAR*)szSQL,strlen(szSQL));
rc = SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle);
//
rc = SQLAllocHandle(SQL_HANDLE_STMT,ConHandle,&StmtHandle);
memset(szSQL,0,1024);
int m_Dsq =0;
m_Dsq = atoi(((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb->m_chDSQ );
sprintf(szSQL,"INSERT INTO ARCDS (ARCDSQ,DBServer,DBSuperUser,DBSuPwd,DBSignature,DBComments,nDsq,noCats,noTabs,noCols,noSTC,noScopes,noDataSets,noEntrances,noEntSets,noPermits) values (\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',%d ,%d , %d, %d,%d ,%d , %d,%d ,%d, %d );"
rc = SQLExecDirect(StmtHandle,(SQLCHAR*)szSQL,strlen(szSQL));
rc = SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle);
// 3.1 end parameters writing into ARCDS
------------------ user details start ------------------------------------*/
// 3.2 begin Isert into Security db , user details
rc = SQLAllocHandle(SQL_HANDLE_STMT,ConHandle,&StmtHandle);
unsigned int nUsq = ((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb->m_noUsers;
int iVal=0;
for ( int nIdx = 0; nIdx < 35000 ; nIdx++)
{
iVal=0;
memset(szSQL,0,1024);
sprintf(szSQL,"insert into ARCdstc (type,dstcSeq,ARCdstcName) values (\'%s\',%d,\'%s\')", chType, ((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb-mp_arcTables[nIdx]->tsq , ((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb->mp_arcTables[nIdx]->tableName
);
rc = SQLExecDirect(StmtHandle,(SQLCHAR*)szSQL,strlen(szSQL));
}
rc = SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle);
// 3.2 end Isert into Security db , user details
//Same code to insert data into 10 other different tables.
Thanks in advance , i will be thankfull to all.
|
|
|
|
|
How is the memory for szSQL managed? I cannot see where it is allocated and freed.
Some optimization points, take them or leave them (ignoring buffer overrun protection that should be added):
1: You do not need to memset(...) the string buffer before you use it - sprintf(...) will NUL-terminiate it for you
2: Do not use sprintf(...) as a replacement for strcpy(...) (in fact, that static string does not really need to be copied to a buffer to be executed)
3: sprintf(...) returns the number of characters it put into the buffer, excluding the terminating NUL so you can use that value to eliminate the calls to strlen(...)
4: I would cache the result of ((ARCAdminDlg*)(AfxGetMainWnd()))->mp_ARCSecDb->mp_arcTables[nIdx] within the loop and not evaluate it multiple times.
In your loop body, implementing the tips in #1 and #3 will eliminate 70000 operations from your loop.
Peace!
-=- James
If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
Thanks a lot for ur reply szSQL is a character array declared as
char szSQL[1024]={0};
i have tried both the option but not much improvement in the memory accumulation. i suppose the problem is with
SQLFreeHandle(SQL_HANDLE_STMT,StmtHandle),it does not free the full memory which is been allcated by
rc = SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&EnvHandle).
|
|
|
|
|
I would like to know if some one has goe got a clue to how to do Image segmentation.
Rishikant
|
|
|
|
|
|
Hi all,
When I run my application, I receive the following error:
The application failed to initialize properly (0xc0150002). Click OK to terminate the apllication.
What can i do to make this work??
Many thanx
The only programmers that are better than C programmers are those who code in 1's and 0's..... 
Programm3r
|
|
|
|
|
|
|
Hi,
Did you check it in second folder ? VS2005 has different folder structure - one Debug/Release foder is in solution folder and the second in project.
And the thread which you reffered ... you wrote that you solved the problem.
You wrote that problem occurs sometimes - perhaps some pointers are not valid or incorect initialized - try to detect which function or which line causes crashes (you can e.g. create an log file)
-----------
Mila
|
|
|
|
|
Thanks for the response Mila,
Maybe I didn't expressed myself correctly. The only thing I want to know is, the principle behind the compiling of a project when using VS2005, in the sense that the CRT dll's cause problems when transfering an exe to another computer. How to prevent it ... I have read articles about that, but those articles did not answer my question. And what steps I can follow to prevent such an occurance.
The previous thread was just for background information, Yes I said that I solved it, but that was till I wrote the next application, and it happened again.
Many thanx
Regards
-- modified at 0:21 Thursday 21st December, 2006
The only programmers that are better than C programmers are those who code in 1's and 0's.....
Programm3r
|
|
|
|
|
hi
I have ATL ActiveX Control.I have placed Dialog box in that.I want to Display an ActiveX Control on that dialog.The ActiveX Control is not visible in Shared but it is visible in static Linking.
I have placed AfxEnableControlContainer but even then there seems to be problem with shared.is there any equivalent for AfxEnableControlContainer in Shared Dll?
how to display ActiveX on another ActiveX in shared mode?
Any links wud do fine...
Thanx in advance
"Every morning I go through Forbes list of 40 richest people in the world. If my name is not in there, I go to work..!!!"
|
|
|
|
|
Hi Guys,
Can anyone tell my how can i create a Global Desktop that can be used by all the users of a system.
I wanna do it programmatically using VC++....
Thanks
~ Selva
|
|
|
|
|
Hello,
i have an litle CListBox control on my dialog, and i like to show items with the gridlines,
ist that posible,i can't find any params to set and show this style?
Any one have some sugestions for me?
regards
break;
|
|
|
|
|
m_ListCtrl.SetExtendedStyle(LVS_EX_GRIDLINES);
mind you sometimes it doesn't work well in XP with theme enabled.
Used on me in a bar: Have you considered suing your brains for non-support?
|
|
|
|
|
Hello,
thanks for answer, but i dont mean the CListCtrl, i mean CListBox, and she dont have function like
SetExtendedStyle(...);
any other way or i dont understand what you mean?
regards
break;
|
|
|
|
|
AFAIK CListBox has not gridlines.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
I could be wrong, but I do not think that the standard List Box control supports lines. The List View control does.
Doing some custom drawing might be a way to get you some lines. There are a few custom-drawn List Box controls on this site you can search for and use as a starting point.
Peace!
-=- James
If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road!
DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
How can disable an item of context popup menu ?
|
|
|
|
|
EnableMenuItem doesnt work?
|
|
|
|
|
Are you using MFC?
"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
how to change scroll bar's color of list box?
Ajit
|
|
|
|
|
I think you cant change color scrollbar of listbox but you can hide main scrollbar and use of your scrollbar see this[^] maybe it some helpfuls
|
|
|
|
|
Hi anyone can help?
How can we detect enter Key pressed in MFC/C++ created by CHTMLEDITVIEW.
ie. When i run my application, I will go to FILE->OPEN->name.ppt
The "name.ppt" (powerpoint slide) will be open.
When i pressed the ENTER key, it does not capture it.
Why?
I used PretranslateMessage()... It doesnt work.
anyone can help?
terr
|
|
|
|
|
Hi everyone,
by sizing the MDI-Child the textboxes are getting ugly ( double border & pieces of the border in the textbox )
At the End of the sizing ( WM_EXITSIZEMOVE ) i make a :
this->RedrawWindow();
this->Invalidate();
this->UpdateWindow();
RedrawControls(); // --> makes a .Invalidate() of all textboxes and labels
but the textboxes keeps ugly.
If i open another window ( f.ex. Explorer ) and i return on my application, all is refreshed nicely.
So, there is a "Refresh" that redraws all. But how can i perform this kind of refresh myself ?
Big thanks
|
|
|
|
|
baerten wrote: this->RedrawWindow();
call the redrawfunction specifing the RDW_ALLCHILDREN flag
nave
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
