LC vs mySQL

jbv at souslelogo.com jbv at souslelogo.com
Sat Dec 7 12:54:54 EST 2013


>
> Indexing is good. You'll lose a little time on writes because of the
> need to update the indexes, but more than make it up on reads. Can you
> move some of the processing into stored procedures on the backend? The
> more processing you can hand off to the MySQL server, the faster your
> response time will be.


AFAIR I had some bad surprises in mySQL indexes, especially fulltext indexes
because of reserved words, or words so common in english that they aren't
included in the index. The situation gets even weirder with french content of
DBs when some words are used both in english & french...
As for stored procedures, this is tempting, but maintenance gets harder when
parts of the code are split between mySQL tables and LC scripts...

jbv





More information about the Use-livecode mailing list