How do I get Pb multithreading?

[mvanrijn]

Hi everyone,

I've been asked to have a look at a system which needs its windows changed to use multithreading.
At the moment there is a window which is run by the users and they might as well run it and go for a cup of coffee. It locks up the whole application. It would be good if we could get the window to work in the background.

It's not possible to speed up the window, it simply summarises half the database. So running it in the back ground would be the best option.

At the moment I'm thinking of trying the following:
1. Remove the select from the main data window making the datawindow external
2. Creating a new non visual object which contains a datastore. Populating this with the select from the main data window.
3. Creating a share between the existing datawindow and the new datastore.
4. Using Posting to do the retrieve on the new datastore.

Is this a sensible approach to this problem?

Are there any tried and tested ways of resolving this problem?

I'd be interested in any feedback I can get. I'm just starting this project, and my Powerbuilder is a bit basic. It would be great to get other people's opinions

Thanks in advance
MJ

 

[Marmaye]

Hello MJ

My suggestion to you is to look at the option of a separate .exe... you can pass what you need it to do by commandline or in a table of your database.

As far as I know, it is the only way to have a process in the background.



David

 

[thekl0wn]

An interesting article on the topic:

http://www.sybase.com/detail?id=47802