'clsThreads Option Explicit Option Compare Text Option Base 0Private Type udtThread Handle As Long Enabled As Boolean End TypePrivate uThread As udtThreadPrivate Const CREATE_SUSPENDED As Long = &H4 Private Const THREAD_BASE_PRIORITY_IDLE As Long = -15 Private Const THREAD_BASE_PRIORITY_LOWRT As Long = 15 Private Const THREAD_BASE_PRIORITY_MAX As Long = 2 Private Const THREAD_BASE_PRIORITY_MIN As Long = -2 Private Const THREAD_PRIORITY_HIGHEST As Long = THREAD_BASE_PRIORITY_MAX Private Const THREAD_PRIORITY_LOWEST As Long = THREAD_BASE_PRIORITY_MIN Private Const THREAD_PRIORITY_ABOVE_NORMAL As Long = (THREAD_PRIORITY_HIGHEST - 1) Private Const THREAD_PRIORITY_BELOW_NORMAL As Long = (THREAD_PRIORITY_LOWEST + 1) Private Const THREAD_PRIORITY_IDLE As Long = THREAD_BASE_PRIORITY_IDLE Private Const THREAD_PRIORITY_NORMAL As Long = 0 Private Const THREAD_PRIORITY_TIME_CRITICAL As Long = THREAD_BASE_PRIORITY_LOWRTPrivate Declare Function CreateThread Lib "kernel32" (ByVal lpThreadAttributes As Any, ByVal dwStackSize As Long, ByVal lpStartAddress As Long, lpParameter As Any, ByVal dwCreationFlags As Long, lpThreadId As Long) As Long Private Declare Function ResumeThread Lib "kernel32" (ByVal hThread As Long) As Long Private Declare Function SetThreadPriority Lib "kernel32" (ByVal hThread As Long, ByVal nPriority As Long) As Long Private Declare Function GetThreadPriority Lib "kernel32" (ByVal hThread As Long) As Long Private Declare Function SuspendThread Lib "kernel32" (ByVal hThread As Long) As Long Private Declare Function TerminateThread Lib "kernel32" (ByVal hThread As Long, ByVal dwExitCode As Long) As Long Public Sub Initialize(ByVal lpfnBasFunc As Long)Dim lStackSize As Long, lCreationFlags As Long, lpThreadId As Long, lNull As Long
On Error Resume Next lNull = 0 lStackSize = 0 lCreationFlags = CREATE_SUSPENDED uThread.Handle = CreateThread(lNull, lStackSize, lpfnBasFunc, lNull, lCreationFlags, lpThreadId) If uThread.Handle = lNull Then MsgBox "Create thread failed!"
End Sub Public Property Get Enabled() As Boolean
On Error Resume Next Enabled = uThread.EnabledEnd Property Public Property Let Enabled(ByVal vNewValue As Boolean)
On Error Resume Next If vNewValue And (Not uThread.Enabled) Then ResumeThread uThread.Handle uThread.Enabled = True ElseIf uThread.Enabled Then SuspendThread uThread.Handle uThread.Enabled = False End IfEnd Property Public Property Get Priority() As LongOn Error Resume Next Priority = GetThreadPriority(uThread.Handle)End Property Public Property Let Priority(ByVal vNewValue As Long)On Error Resume Next If vNewValue = -2 Then Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_LOWEST) ElseIf vNewValue = -1 Then Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_BELOW_NORMAL) ElseIf vNewValue = 0 Then Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_NORMAL) ElseIf vNewValue = 1 Then Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_ABOVE_NORMAL) ElseIf vNewValue = 2 Then Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_HIGHEST) End IfEnd Property Private Sub Class_Terminate()On Error Resume Next Call TerminateThread(uThread.Handle, 0)End Sub'call Dim myThread As New clsThreads On Error Resume Next With myThread .Initialize AddressOf 子程序或函数 .Enabled = True End With
Option Explicit
Option Compare Text
Option Base 0Private Type udtThread
Handle As Long
Enabled As Boolean
End TypePrivate uThread As udtThreadPrivate Const CREATE_SUSPENDED As Long = &H4
Private Const THREAD_BASE_PRIORITY_IDLE As Long = -15
Private Const THREAD_BASE_PRIORITY_LOWRT As Long = 15
Private Const THREAD_BASE_PRIORITY_MAX As Long = 2
Private Const THREAD_BASE_PRIORITY_MIN As Long = -2
Private Const THREAD_PRIORITY_HIGHEST As Long = THREAD_BASE_PRIORITY_MAX
Private Const THREAD_PRIORITY_LOWEST As Long = THREAD_BASE_PRIORITY_MIN
Private Const THREAD_PRIORITY_ABOVE_NORMAL As Long = (THREAD_PRIORITY_HIGHEST - 1)
Private Const THREAD_PRIORITY_BELOW_NORMAL As Long = (THREAD_PRIORITY_LOWEST + 1)
Private Const THREAD_PRIORITY_IDLE As Long = THREAD_BASE_PRIORITY_IDLE
Private Const THREAD_PRIORITY_NORMAL As Long = 0
Private Const THREAD_PRIORITY_TIME_CRITICAL As Long = THREAD_BASE_PRIORITY_LOWRTPrivate Declare Function CreateThread Lib "kernel32" (ByVal lpThreadAttributes As Any, ByVal dwStackSize As Long, ByVal lpStartAddress As Long, lpParameter As Any, ByVal dwCreationFlags As Long, lpThreadId As Long) As Long
Private Declare Function ResumeThread Lib "kernel32" (ByVal hThread As Long) As Long
Private Declare Function SetThreadPriority Lib "kernel32" (ByVal hThread As Long, ByVal nPriority As Long) As Long
Private Declare Function GetThreadPriority Lib "kernel32" (ByVal hThread As Long) As Long
Private Declare Function SuspendThread Lib "kernel32" (ByVal hThread As Long) As Long
Private Declare Function TerminateThread Lib "kernel32" (ByVal hThread As Long, ByVal dwExitCode As Long) As Long
Public Sub Initialize(ByVal lpfnBasFunc As Long)Dim lStackSize As Long, lCreationFlags As Long, lpThreadId As Long, lNull As Long
On Error Resume Next
lNull = 0
lStackSize = 0
lCreationFlags = CREATE_SUSPENDED
uThread.Handle = CreateThread(lNull, lStackSize, lpfnBasFunc, lNull, lCreationFlags, lpThreadId)
If uThread.Handle = lNull Then MsgBox "Create thread failed!"
End Sub
Public Property Get Enabled() As Boolean
On Error Resume Next
Enabled = uThread.EnabledEnd Property
Public Property Let Enabled(ByVal vNewValue As Boolean)
On Error Resume Next
If vNewValue And (Not uThread.Enabled) Then
ResumeThread uThread.Handle
uThread.Enabled = True
ElseIf uThread.Enabled Then
SuspendThread uThread.Handle
uThread.Enabled = False
End IfEnd Property
Public Property Get Priority() As LongOn Error Resume Next
Priority = GetThreadPriority(uThread.Handle)End Property
Public Property Let Priority(ByVal vNewValue As Long)On Error Resume Next
If vNewValue = -2 Then
Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_LOWEST)
ElseIf vNewValue = -1 Then
Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_BELOW_NORMAL)
ElseIf vNewValue = 0 Then
Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_NORMAL)
ElseIf vNewValue = 1 Then
Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_ABOVE_NORMAL)
ElseIf vNewValue = 2 Then
Call SetThreadPriority(uThread.Handle, THREAD_PRIORITY_HIGHEST)
End IfEnd Property
Private Sub Class_Terminate()On Error Resume Next
Call TerminateThread(uThread.Handle, 0)End Sub'call
Dim myThread As New clsThreads
On Error Resume Next
With myThread
.Initialize AddressOf 子程序或函数
.Enabled = True
End With
请搜索 Com+,MTS ,连接池 等关键字
如果你做的是进行100次大的循环累加,每次循环需要5秒,那么单线程处理需要大约500秒,多线程处理时间可能大于500秒。因为线程间的切换需要消耗CPU时间的。特别是线程比较多的时候,系统开销较大。
需要注意的是,VB支持“调用”MTA和STA,但它仅仅支持创建STA。应该清楚,对多个STA线程的支持与在MTA中创建的对象的支持是不同的。