LC vs mySQL

Robert Sneidar slylabs13 at me.com
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. 

Bob


On Dec 8, 2013, at 12:30 PM, Mark Wieder <mwieder at ahsoftware.net> 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 gmail.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





More information about the Use-livecode mailing list