Setup Questions for LiveCode Server

[Pierre Sahores]

Hi Dave,

See as a trustable resume : http://www.openlogic.com/wazi/bid/188125/

The main MySQL's bottleneck in current use reside in its very poor ability to handle more than some write requests peer second while PostgreSQL supports up to thousand's one under appropriate hardware. MySQL is more reliable as a read-only access DB but in the real world, DB are writable too, is't ? ;D

The PostgreSQL and MySQL SQL syntax learning curves are identical but most of the error messages PostgreSQL can provide us along the development cycle of a new app are always perfectly clear and helpful to target our own SQL syntax mistakes.

I prefer, for my own, work with PostgreSQL than with Oracle alike i had to do over the years for different customers including EADS Astrium under the Solaris or Linux platforms.

If your customers decide to use MySQL indeed, the best is to choose the innoDB engine to empower your works (partially ACID compliant) instead of the MyISAM one witch is mostly not reliable at all in the real world.

Regards,

Pierre

PS : Mastering SQL is not difficult at all and, in making an extensive use of JOIN clauses, it can become very performant and elegant in about resources use + no far from instantaneous response times (applying PostgreSQL and other ACID compliant DB systems only).

Le 22 oct. 2013 à 09:59, Dave Kilroy a écrit :

> Pierre thanks for this - can you expand a bit more on use of MySQL - I use
> MySQL but so far only handling pretty tiny amounts of data: am I building in
> a performance penalty using MySQL even using simple operations with small
> amounts of data or do the differences only manifest when MySQL is being
> stressed?
> 
> Kind regards
> 
> Dave
> 
> 
> Pierre Sahores-2 wrote
>> simple : never use MySQL as the SQL back-office because it's architecture
>> makes it a very slow SQL engine (very bad complexity in time calculations
>> ability); use any ACID SQL compliant server instead (PostgreSQL,
>> Valentina,…).
> 
> 
> 
> 
> 
> -----
> "Some are born coders, some achieve coding, and some have coding thrust upon them." - William Shakespeare & Hugh Senior
> 
> --
> View this message in context: http://runtime-revolution.278305.n4.nabble.com/Setup-Questions-for-LiveCode-Server-tp4671336p4671347.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com