LC vs mySQL
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.
On Dec 8, 2013, at 12:30 PM, Mark Wieder <mwieder at ahsoftware.net> wrote:
> 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:
More information about the Use-livecode