LC vs mySQL
mwieder at ahsoftware.net
Sun Dec 8 15:30:56 EST 2013
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.
ahsoftware at gmail.com
More information about the Use-livecode