database access bandwidth: PHP vs. Revolution

Josh Mellicker josh at dvcreators.net
Thu May 18 19:24:36 EDT 2006


Forgive the noob question:

At first glance it appears that accessing a database with Rev "hits"  
the database for every column in every record in the repeat loop.

Whereas it seems that a SELECT query executed from, say, PHP, puts  
all the data returned into an array in one query, then the data can  
be extracted from the array in memory as needed.

Does Rev put a greater load on the database than a single PHP SELECT  
query?

(Or does is the PHP SELECT query kind of like a loop that has to  
"hit" every column of every record anyway?)



More information about the use-livecode mailing list