Cgi and Database (stick to standards)

[viktoras didziulis]

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...).

Viktoras

Sadhunathan Nadesan wrote:
> FYI
>
> PostgreSQL is free.
>
> Sadhu
>
>
>
>   
>> ............
>> 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:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>