Home > database >  Difficult problem, PB can't data window for multithreaded queries?
Difficult problem, PB can't data window for multithreaded queries?

Time:09-26

Want to implement the data window multi-threaded retrieve,
However, Shared object only to deal with non visual object business,
When it comes to visual operation, the Shared object is unable to call,
If I want to implement a data window in another thread to execute queries, and the main thread is able to respond to user actions, will not be able to achieve?

CodePudding user response:

This is one of the pb defects,

CodePudding user response:

Pb should do, whether can be set by the developer to use multithreading, for the update, delete, insert statement, are not allowed to use multithreading, for dynamic SQL statements, are not allowed to use multithreading, the select statement data window (for example), if the user specified by the multi-thread query for filling the data, allows multithreading, otherwise, the single thread (the default), during the period of multithreading, the datawindow read-only, do not allow the operation,

CodePudding user response:

Sbigwolf, said your idea is good, can be sent to sybase,

CodePudding user response:

PB now multi-threaded, actually was on the server side in the three layers structure of distributed processing nvo, don't you have three layers, put it in the front end realize multithreading, server-side nvo how is it possible to realize visualization operation, you said a data window in another thread to execute queries, and the main thread is able to respond to user actions, completely can be implemented for variety and use the datastore to query, check out the results to the datawindow, why have to drill the deep end?

CodePudding user response:

reference 4 floor sjlion response:
PB now multi-threaded, actually was on the server side in the three layers structure of distributed processing nvo, don't you have three layers, put it in the front end realize multithreading, server-side nvo how is it possible to realize visualization operation, you said a data window in another thread to execute queries, and the main thread is able to respond to user actions, completely can be implemented for variety and use the datastore to query, check out the results to the datawindow, why have to drill the deep end?

Multi-thread asynchronous operations, is the nature of the impact is not big for the UI, you use the datastore to check, the program does not just there, such as stuck? Want is not stuck, can also perform window re-paint, etc, etc

CodePudding user response:

Yes, it is asynchronous, otherwise called multithreading? Now that is another thread, the main thread waiting for? Do anything she likes

CodePudding user response:

Want to download the data, and let the user operation, can be implemented in PB, just can have the hourglass, and the UI of the above operation will be a little slow,

In addition, write the code, and also need a little bit of program and system development cost, and the meaning is not very big,,,

CodePudding user response:

If the original poster is single-core CPU, say what all useless, if it is a multi-core, thread has no effect on the main thread after being thrown, neither have the hourglass, also won't delay, for the first time to write the code will be a little trouble, of course, this depends on your deal with the complexity of the logic

CodePudding user response:

A little complicated, PB has solution, have a look at the help of SharedObjectGet function,

CodePudding user response:

It is just a show, I think is normal operation
  • Related