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

[Chris Hansen]

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
>