LC vs mySQL

Robert Sneidar slylabs13 at
Sun Dec 8 20:56:00 EST 2013

As usual, “it depends”. Thousands of records? Full text search no problem. Millions of records? You may have a performance issue. 


On Dec 8, 2013, at 12:30 PM, Mark Wieder <mwieder at> wrote:

> jbv-
> Saturday, December 7, 2013, 9:54:54 AM, you wrote:
>> 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 Pete said, generating an index doesn't necessarily guarantee a
> speed increase. I'm not sure of the utility of a fulltext index, and I
> don't think generating an index on a numeric field will gain you
> anything. But in other cases you may see a marked difference.
> -- 
> -Mark Wieder
> ahsoftware at
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the Use-livecode mailing list