maybe i don't understand but what about:

`trigger
execute on client("@";"flagPoll")

`flagPoll
c_boolean(<>flagPoll)
<>flagPoll:=true

...

if(<>flagPoll)
>   $x:=Records in table([ServerMigrations])
        <>flagPoll:=false
else
         `skip 99,999 calls to server
end if

> On Oct 19, 2017, at 11:31 AM, Jeffrey Kain via 4D_Tech <[email protected]> 
> wrote:
> 
> Decided to test it. Here are the results, running interpreted, client-server 
> against a server under very low load:
> 
> Records in table: 565 ms
> Semaphore polling: 2482 ms
> Query into variable: 2749 ms
> 
> Here's my test code:
> 
> C_LONGINT($msRIT;$msSEM;$msQUERY;$x;$n)
> C_BOOLEAN($b)
> $n:=1000
> 
> $msRIT:=Milliseconds
> For ($i;1;$n)
>   $x:=Records in table([ServerMigrations])
> End for 
> $msRIT:=Milliseconds-$msRIT

**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to