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 <[EMAIL PROTECTED]>
Subject: Re: Cgi and Database (stick to standards)
To: How to use Revolution <[email protected]>
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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
