Cgi and Database (stick to standards)

Bernard Devlin bdrunrev at gmail.com
Fri Feb 8 03:59:20 EST 2008


I'm not sure what kind of database requirements you have.  But in my
tests using queries performing multiple joins on several tables
containing between 1 million and 9 million rows each, Rev cgi
completely blew away Java and relational databases:

http://lists.runrev.com/pipermail/use-revolution/2008-January/106071.html

If you need multi-user/multi-application update/insert access to the
data, then Rev is probably not the right solution.  For other
situations, I would say don't dismiss Rev's native data structures
without thorough testing of the speed differences when compared to a
RDBMS.

Bernard

On 2/7/08, Hershel Fisch <hershf at rgllc.us> wrote:
> > Another option is to use a conventional flat file database (i.e. text
> > file). I've been using that with Rev cgi with no problem.
> I don¹t think that it will work with a million record plus, db.
> >



More information about the Use-livecode mailing list