Cgi and Database (stick to standards)
viktoras at ekoinf.net
Sat Feb 16 03:52:59 CST 2008
from my experience mysql is faster than sqlite in joins, unless you
manually optimise your sql queries for sqlite ;-), in most cases using
subqueries. Plus mysql is multiuser and omnipresent, which matters...
To make sqlite multiuser you will have to implement your own database
locking mechanism, or use tools that have it already implemented (like
modsqlite for apache). Possibly valentina db is one of the best choices
(and I am waiting for my valentine days license to test it without
limitations :-) ), but if you buy hosting services, then I guess you are
limited to mysql, sqlite and sometimes postrgresql (which people say is
slower than mysql...).
Sadhunathan Nadesan wrote:
> PostgreSQL is free.
>> From: Hershel Fisch <hershf at rgllc.us>
>> Subject: Re: Cgi and Database (stick to standards)
>> To: How to use Revolution <use-revolution at lists.runrev.com>
>>>> Bernard Devlin wrote:
>>>>>> I'm not sure what kind of database requirements you have.
>> SQL rdbms, and I was thinking to use "sqLITE" because its fast even with
>> big bases and most hosting sites use mySql which slows down as the database
>> grows. I wanted to use PostgreSQL but I don¹t find any body with it for a
>> decent price
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode