Cgi and Database (stick to standards)

Ruslan Zasukhin sunshine at public.kherson.ua
Sat Feb 16 08:20:04 CST 2008


On 16/2/08 11:52 AM, "viktoras didziulis" <viktoras at ekoinf.net> wrote:

Hi Victoras,

> from my experience mysql is faster than sqlite in joins, unless you
> manually optimise your sql queries for sqlite ;-), in most cases using
> subqueries. 

I am ready to see example :-)
If you want on Valentina list.

> Plus mysql is multiuser  and omnipresent, which matters...

right

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

That is right, 

It seems that all depend on users tasks. I did have feedbacks from Valentina
developers that yes Postgre comparing to mySQL is much slow (in times). But
not so far I have hear opinion that Postgre (latest?) did win mySQL on
joins.

So keep always in mind that DB tasks can be VERY different. For some tasks
one dbms can be better, for other tasks another. It is good, as army
soldier, to have skills with few kinds of weapon :-)

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]





More information about the use-livecode mailing list