See if this FB class I wrote does anything to assist you.

http://www.planetsquires.com/protect/fo ... pic=3984.0

Well Dave, I'm just another older guy now and pursue trout, salmon, and, grayling with my beloved bamboo with flies I tie. In between fishing trips, I sling a bit of code around and hike and travel with my wife who has beat me to retirement by a few years. I do like a pint a few times per month and ...

You are da man Dave. Have a pint on me....

Rick

This is why in my class, I don't reuse the TP_WORK object. I can pass whatever is needed at the time. ' ===================================================================================== ' Create Thread Work ' ===================================================================================== P...

Your comparison results are similar to mine although I only used 1000 threads.

Links I found useful for tuning of thread pools is at:

https://blogs.msdn.microsoft.com/pedram ... ol-thread/

http://www.thejoyofcode.com/Tuning_the_ThreadPool.aspx

Wow! Thanks for the feedback. The overhead for creating threads is higher than I had imagined and yours is the first proof that thread pools have their place. I'm looking forward towards throwing that proverbial brick wall at my SQLite server class. I have a connection pool class that manages the SQ...

You may be correct. I only included the environment api's since I thought threads working with SQLite would be thought of as "long". I have a lot of testing remaining and I'll find out when I throw a few hundred connections at my server class as fast as I can create them. 70 bits just mean...

Grab my class and sample script and with your work flow. I'd be interested in seeing if it holds up.

Welcome to the 64 bit world...

I'm the PB guy having transitioned to FB. I'm developing SQLite Client/Server classes when the whole threadpool api set came into view. See my take at: https://github.com/breacsealgaire/FreeBasic-32-64-Windows-SQLite-Class What I found out is that I can have a thread cleanup group without a callback...

Added a thread pool class that the server class will eventually use.

https://github.com/breacsealgaire/FreeB ... Lite-Class

Not knowing much about things, I put this small snippet of code together and it seems to work with both 32 and 64 bit compiles. const _WIN32_WINNT = &h0602 #INCLUDE ONCE "windows.bi" declare sub myThread (byval Instance as PTP_CALLBACK_INSTANCE, byval Context as PVOID, byval Work as PT...

Does anybody have any experience using the windows thread pool api's, and, what are best practices?

1. CreateThreadpool
2. SetThreadpoolThreadMaximum
3. SetThreadpoolThreadMinimum
4. CreateThreadpoolWork
5. SubmitThreadpoolWork
6. CloseThreadpoolWork
7. CloseThreadPool

If I run a CreateThread, can I use the thread handle returned with (Windows) WaitForSingleObject(hThread,0) = WAIT_OBJECT_0? When that is true, the thread should be done, and, now, free the thread handle using ThreadDetach?

This SQLite Windows collection is the beginning of a complete set of classes for a client/server group. Over the next several months, there are basically three additional classes. Socket (already in place with preliminary testing), Client, and, Server classes after which all the tools will be in pla...

Added Windows crypto class useful for SQLite client/server authentication with example of one way to design a handshake.