Maintaining selections/sets on server

[Bill Weale]

I have to maintain a "group" of records which will be quickly  
available to any client. It looks to me that, in a server process,  
creating a set and then calling BOOLEAN ARRAY FROM SET() or LONGINT  
ARRAY FROM SELECTION() are options. (Any other suggestions?) Which is  
preferred?


I'll use trigger methods to determine if the selection must be  
updated, but I assume a RESUME PROCESS() call to the server server  
method from the trigger is quickest--to "decouple" the TM from the  
server Query?

Should I use GET PROCESS VARIABLE() to retrieve the array directly  
from the server process or should I store the array as a blob in a  
record?

Thanks,

Bill Weale


**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************

[Arnaud de Montard]

Le 17 nov. 08 à 18:21, Bill Weale a écrit :

>
> I have to maintain a "group" of records which will be quickly  
> available to any client. It looks to me that, in a server process,  
> creating a set and then calling BOOLEAN ARRAY FROM SET() or LONGINT  
> ARRAY FROM SELECTION() are options. (Any other suggestions?) Which  
> is preferred?

make your choice:
set = 1 bit by record in table
selection = 4 byte by record in selection

> [...]
> Should I use GET PROCESS VARIABLE() to retrieve the array directly  
> from the server process or should I store the array as a blob in a  
> record?

before reading variable on server, you'll also have to unblob: not  
very interresting  ;-)

--
Arnaud de Montard



**********************************************************************
4D Server v11 SQL has arrived!
Buy it NOW at http://store.4ddepot.com

4th Dimension Internet Users Group (4D iNUG)
FAQ:  http://www.4d.com/support/faqnug.html
Archive:  http://dir.gmane.org/gmane.comp.lang.inug-4d.tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
Post: mailto:4d_tech@...
Options: https://lists.4d.com/mailman/listinfo/4d_tech
**********************************************************************