Re: Overlapped IO (Sockets) and _beginethreadEx

From: Len Holgate (Len.Holgate_at_JetByte.com)
Date: 02/26/04


Date: Thu, 26 Feb 2004 09:23:35 -0000

We found that the best way to deal with this was to have a pool of threads
for the database access and a pool for IO. The IO threads post completed
requests to the database pool and that pool handles the database.

We wrote an article about this design here:
http://www.jetbyte.com/portfolio-showarticle.asp?articleId=38&catId=1&subcatId=2,
the article contains complete source code for a IOCP server framework and
has an example server that uses a seperate thread pool for business logic
(db) work. Updates to the code are available here
http://www.lenholgate.com/archives/000082.html.

The design means that IO threads are always available and database requests
get queued in the IOCP between the two pools. The db pool can grow and
shrink within predetermined limits as demand demands...

-- 
Len Holgate - http://www.lenholgate.com
JetByte Limited - http://www.jetbyte.com
The right code, right now.
Contract Programming and Consulting Services.


Relevant Pages

  • RE: Restored to New server and cannot logon to STS_Config
    ... > The Application Pools user is "Network Services" ... > the database access tab. ... you must first determine the application pool identity. ... Right-click the virtual server that is running Windows SharePoint ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Access Databases & IIS 6.0
    ... PID to Application Pool." ... You don't need to reboot the server. ... I administer a Windows Server 2003 running IIS 6. ... Unable to establish connection to database. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Oracle Performance -- Possible Disk Bottleneck
    ... have a disk bottleneck here. ... The DBA was aware of a problem with a particular ... unnecessary thrashing in the default pool due to those objects. ... application and database schema design problems. ...
    (comp.databases.oracle.server)
  • Re: Ive about had it with WSS!
    ... Sharepoint went down on our main server, I fought with that for 2 days ... "Unable to connect to database. ... Make sure the account for the application pool has appropriate ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Using RAC for 25+ small to medium sized database
    ... >each with buffer cache, large pool, shared pool, java pool, redo ... >buffers plus each of these instances would have up to 20 oracle ... >to each other from one blade server to another. ... >non-RAC database to RAC, 5 sets of archive/redo logs, 5 alert log files ...
    (comp.databases.oracle.server)