On 16/2/08 11:52 AM, "viktoras didziulis" <[EMAIL PROTECTED]> 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] _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution