[FX.php List] case sensitive query + indexing question]

[Joel Shapiro]

Hi Alex

By default FM should index fields the first time they're searched or  
used as a "right side" match field in a relationship.  I don't think  
I've ever intentionally turned indexing *on*, although there have  
been times that I have manually turned it off -- such as with  
calculations or auto-enters that I want to re-evaluate at the time  
they're called.

I can't think of a good reason to have indexing off on a calc field  
like RecID, since that should unchanging.

Best,
-Joel


On Jul 19, 2007, at 4:29 PM, Chris Hansen wrote:

> Alex,
>
> I'd say that if you're going to search on it, index it.  As I  
> understand it, the main cost of indexing is increased storage  
> space.  Best,
>
> --Chris Hansen
>   FileMaker 8 Certified Developer
>   FileMaker 7 Certified Developer
>   Creator of FX.php
>   "The best way from FileMaker to the Web."
>   www.iViking.org
>
>
> On Jul 19, 2007, at 5:25 PM, Alex Gates wrote:
>
>>
>> Thanks Chris and Troy -
>>
>> That worked.  Thank you both -
>> Chris - I didn't try your calculated field method - but thanks for  
>> the
>> tip... in this case its OK to always have it case sensitive.
>>
>> Finally - (I'm on a roll here with the questions... sorry)
>> I was wondering if anyone has any insight on what fields to index and
>> what fields to turn indexing off.
>>
>> When should I and when shouldn't I be indexing?
>>
>> Looking at my DB, I realized I turned indexing off on my calculated
>> RecID (get(RecID)) field.  I don't recall why.
>> Maybe my LAJAX would be a little speedier on the find if I indexed  
>> those...
>>
>> Thanks again -
>>
>> (I owe some drinks at DevCon.)
>>
>>
>>
>>
>>
>> Chris Hansen wrote:
>>> Alex,
>>> The easiest solution is probably to use unicode indexing on that  
>>> field.  Of course, that makes all searches case sensitive, but  
>>> that's often what you want in such cases.  Come to think of it, I  
>>> think it would work to have two fields: one a calc with unicode  
>>> indexing, the other the main field with the default indexing (or  
>>> vice versa).  That would give you the flexibility to have case  
>>> sensitivity or not, as the situation dictated.  HTH
>>> --Chris Hansen
>>>   FileMaker 8 Certified Developer
>>>   FileMaker 7 Certified Developer
>>>   Creator of FX.php
>>>   "The best way from FileMaker to the Web."
>>>   www.iViking.org
>>> On Jul 19, 2007, at 4:14 PM, Alex Gates wrote:
>>>> While I'm at it...
>>>>
>>>> Anyone know a trick to make queries case sensitive?
>>>>
>>>> for example, if alex is my username, I can still log in with  
>>>> Alex or ALEX or aLeX.
>>>> Any special trick to make it case sensitive?
>>>>
>>>>
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list