dbTalk Databases Forums  

Custom OLAP processing application, multithreading and partitions...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Custom OLAP processing application, multithreading and partitions... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default Custom OLAP processing application, multithreading and partitions... - 11-24-2004 , 09:49 AM






Hi,

I've created my own process utility to process my cubes and dimensions.
To improve the performance, I'm using some threads to do my processes.

But each thread wait for the completion of the process of another thread
before starting.
So the result is not a parallel processing...

what can I do?

Thanks.

Jerome.



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Custom OLAP processing application, multithreading and partitions... - 11-25-2004 , 02:02 AM






DSO is written in VB6 and is thus single apartment-model threaded.
You need to go to multiple processes; not just multiple threads.
See the Parallel Processing Utility (which is distributed in source) to see
how you can do it.
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:
Hi,

I've created my own process utility to process my cubes and dimensions.
To improve the performance, I'm using some threads to do my processes.

But each thread wait for the completion of the process of another thread
before starting.
So the result is not a parallel processing...

what can I do?

Thanks.

Jerome.





Reply With Quote
  #3  
Old   
Jéjé
 
Posts: n/a

Default Re: Custom OLAP processing application, multithreading and partitions... - 11-25-2004 , 07:36 AM



well.. I don't want to use it due to a lack of functionalities its why I
write my own utility.

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Quote:
DSO is written in VB6 and is thus single apartment-model threaded.
You need to go to multiple processes; not just multiple threads.
See the Parallel Processing Utility (which is distributed in source) to
see
how you can do it.
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:uDabSzj0EHA.3408 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi,

I've created my own process utility to process my cubes and dimensions.
To improve the performance, I'm using some threads to do my processes.

But each thread wait for the completion of the process of another thread
before starting.
So the result is not a parallel processing...

what can I do?

Thanks.

Jerome.







Reply With Quote
  #4  
Old   
Jéjé
 
Posts: n/a

Default Re: Custom OLAP processing application, multithreading and partitions... - 11-25-2004 , 10:21 AM



ok,

my threads simply call the ProcessPartition.exe utility with the right
parameters and wait for the completion of the call.
So now I have parrallel process in progress...

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:
well.. I don't want to use it due to a lack of functionalities its why I
write my own utility.

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote in message
news:uPLMoUs0EHA.2156 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
DSO is written in VB6 and is thus single apartment-model threaded.
You need to go to multiple processes; not just multiple threads.
See the Parallel Processing Utility (which is distributed in source) to
see
how you can do it.
http://www.microsoft.com/downloads/d...DisplayLang=en
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote in message
news:uDabSzj0EHA.3408 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi,

I've created my own process utility to process my cubes and dimensions.
To improve the performance, I'm using some threads to do my processes.

But each thread wait for the completion of the process of another thread
before starting.
So the result is not a parallel processing...

what can I do?

Thanks.

Jerome.









Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.