LC vs mySQL

Mark Wieder mwieder at ahsoftware.net
Sun Dec 8 15:30:56 EST 2013


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





More information about the Use-livecode mailing list