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
$msSEM:=Milliseconds
For ($i;1;$n)
$b:=Test semaphore("SomeSemaphore")
End for
$msSEM:=Milliseconds-$msSEM
$msQUERY:=Milliseconds
For ($i;1;$n)
SET QUERY DESTINATION(Into variable;$x)
QUERY([ServerMigrations];[ServerMigrations]StartDate=!2017-10-18!)
SET QUERY DESTINATION(Into current selection)
End for
$msQUERY:=Milliseconds-$msQUERY
ALERT("Records in table: "+String($msRIT)+" ms.\n"+\
"Semaphore polling: "+String($msSEM)+" ms.\n"+\
"Query into variable: "+String($msQUERY)+" ms.")
> On Oct 19, 2017, at 2:06 PM, Timothy Penner <[email protected]> wrote:
>
> Got it, the two concepts just seem completely different. One requires a query
> the other doesn’t.
> I would assume the query would slow it down, but I could be wrong or the
> difference could be insignificant...
>
> Sorry if this isn’t much help.
>
> -Tim
**********************************************************************
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]
**********************************************************************
