|
Home > Archive > MS Access Multiuser > April 2005 > DAO 3.6 in Multi-user Env via COM+ server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DAO 3.6 in Multi-user Env via COM+ server
|
|
|
| I have a VB 6.0 component that uses DAO 3.6 library to read MS Access 2000
db/table (just for ReadOnly operation). I created a standard exe that calls
this VB component in a 5 second interval. Say for instance this VB component
takes 10 seconds to complete a task when deployed out of COM+ server, that
means, I used regsvr32 to register the vb component. But, it takes anywhere
between 30 seconds to an hour to do the same job when deployed in COM+
server.
I am wondering how the performance gets this big hit for a VB component when
deployed in a COM+ server. Any help would be appreciated.
| |
|
| I would like to add few more things:Opening of access db/table, seek
operation is very slow when the vb component is deployed in com+ server.
Locking of db is a problem as well, although I open the db in shared mode and
not in exclusive mode.
"Bala" wrote:
> I have a VB 6.0 component that uses DAO 3.6 library to read MS Access 2000
> db/table (just for ReadOnly operation). I created a standard exe that calls
> this VB component in a 5 second interval. Say for instance this VB component
> takes 10 seconds to complete a task when deployed out of COM+ server, that
> means, I used regsvr32 to register the vb component. But, it takes anywhere
> between 30 seconds to an hour (sometimes the access db is never opened and hence the system starts hanging) to do the same job when deployed in COM+
> server.
>
> I am wondering how the performance gets this big hit for a VB component when
> deployed in a COM+ server. Any help would be appreciated.
>
| |
| david epsom dot com dot au 2005-04-27, 3:24 am |
| I think you should ask this question again in a VB group and a COM+ group.
Unless by accident, there won't be anyone here familiar with COM+
(david)
"Bala" <Bala@discussions.microsoft.com> wrote in message
news:A33AB412-68CA-49D1-BADE- 5B2D45DBA1EC@microso
ft.com...
>I have a VB 6.0 component that uses DAO 3.6 library to read MS Access 2000
> db/table (just for ReadOnly operation). I created a standard exe that
> calls
> this VB component in a 5 second interval. Say for instance this VB
> component
> takes 10 seconds to complete a task when deployed out of COM+ server, that
> means, I used regsvr32 to register the vb component. But, it takes
> anywhere
> between 30 seconds to an hour to do the same job when deployed in COM+
> server.
>
> I am wondering how the performance gets this big hit for a VB component
> when
> deployed in a COM+ server. Any help would be appreciated.
>
| |
|
| Thanks David.
(I asked here because the issue was accessing the data in MS Access)
"david epsom dot com dot au" wrote:
> I think you should ask this question again in a VB group and a COM+ group.
>
> Unless by accident, there won't be anyone here familiar with COM+
>
> (david)
>
> "Bala" <Bala@discussions.microsoft.com> wrote in message
> news:A33AB412-68CA-49D1-BADE- 5B2D45DBA1EC@microso
ft.com...
>
>
>
|
|
|
|
|