Hall of Fame

1. Infinity08574,140
2. evilrix205,131
3. mrjoltcola187,812
4. jkr149,687
5. ozo134,525
6. itsmeandn...92,796
7. masheik68,342
8. pgnatyuk63,359
9. Kdo57,090
10. sunnycoder56,749
11. Let_Me_Be52,746
12. fridom50,492
13. DanRollins27,537
14. _phoenix_19,551
15. woolmilkp...18,264
16. jaime_oliv...17,386
17. lhl6016,254
18. trinitrotolu...15,372
19. abel15,296
20. Zoppo13,150
21. HalfAsleep12,994
22. ikework12,814
23. ewest0212,750
24. duncan_roe12,564
25. Subrat2...12,163

1. Infinity081,728,400
2. sunnycoder1,090,983
3. jkr926,308
4. Kdo882,217
5. ozo600,952
6. evilrix416,261
7. grg99299,856
8. PaulCasw...299,635
9. itsmeandn...281,273
10. jaime_oliv...231,198
11. fridom225,588
12. mrjoltcola187,812
13. brettmjohn...182,528
14. ankuratvb157,866
15. imladris147,553
16. cwwkie129,383
17. Axter100,363
18. akshayxx96,671
19. josgood83,881
20. AlexViroc...70,328
21. gj6270,227
22. rbr69,997
23. masheik68,342
24. cup64,403
25. pgnatyuk63,359

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.0

2.5 second "pause" between when code exits and command line comes back (ThreadExit)

Asked by BillBach in C Programming Language, Windows Programming

Tags: C

I have a Win32 command line application that uses ODBC calls to access any database. Everything seems to be working great, except for a minor performance issue that we are now battling. At the end of the code, as the application is termination, we are seeing a "pause" that can run as long as 2.5 seconds (or more).

This is not in my code, but rather is AFTER my code exits. The end of the application looks like this:
      if(DisplayTimes)
            PrintTime("Tearing Down SQL Environment");
      TearDownSQLEnvironment();
      if(DisplayTimes)
            PrintTime("Complete!");
      exit(ReturnStatus);
}

When run, I get a list of timestamps including the following:

18:29:43.650: Finished Data Read
18:29:43.650: Free Statement Handle
18:29:43.650: Disconnect from Database
18:29:43.728: Tearing Down SQL Environment
18:29:43.728: Complete!

As you can see, the call to disconnect from the database takes some time, but tearing down the environment takes almost no time at all. The problem, though, is that the program is exiting, but control is not returned to the command line for some time thereafter. The code snippet shows a Process Monitor trace that shows that the Thread Exit call is occurring at 18:29:43.719 (actually a bit BEFORE the program actually finishes, but this could be a timer issue). In any event, nothing happens for the next 2.5 seconds and we sit there waiting for the command prompt to come back. Even checking through the intervening calls with ProcMon, I don't see anything other than the typical "idle chatter" of AV and other agents. (No, AV is not the issue, as I can duplicate the problem on other systems with no AV code.)

The application I am using is called SQLExec, and is also available for download from www.goldstarsoftware.com/tools.asp. You can test it yourself to any ODBC database by issuing a command like this:
SQLEXEC <DSNName> "SELECT TOP 1 * FROM TableName" /DT

The app is fast, but the delay FOLLOWING the app is positively maddening! Help!

I've surmised that this is unloading of DLL's related to ODBC and the database, but I have not found a way to confirm this as of yet.

View the Solution FREE for 30 Days

         
             17145	18:29:43.7198046	sqlexec.exe	4640	Thread Exit		SUCCESS	User Time: 0.0000000, Kernel Time: 0.0000000
18:29:46.2529335	sqlexec.exe	4640	RegOpenKey	HKLM\Software\Microsoft\Windows NT\CurrentVersion\GRE_Initialize	SUCCESS	Desired Access: Read
18:29:46.2529836	sqlexec.exe	4640	RegQueryValue	HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\GRE_Initialize\DisableMetaFiles	NAME NOT FOUND	Length: 20
18:29:46.2530469	sqlexec.exe	4640	RegCloseKey	HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\GRE_Initialize	SUCCESS	
18:29:46.2531342	sqlexec.exe	4640	Thread Exit		SUCCESS	User Time: 0.0312500, Kernel Time: 0.2031250
18:29:46.2542871	sqlexec.exe	4640	Process Exit		SUCCESS	Exit Status: 0, User Time: 0.0468750, Kernel Time: 0.1562500
18:29:46.2545963	sqlexec.exe	4640	CloseFile	C:\Develop\Win32\SQLExec\Release	SUCCESS	
18:29:46.2548343	sqlexec.exe	4640	CloseFile	C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03	SUCCESS

20091111-EE-VQP-92 / EE_QW_2_20070628

2.5 second "pause" between when code exits and command line comes back (ThreadExit)

Asked by BillBach in C Programming Language, Windows Programming

Tags: C

About this solution