>>>>BTW, here is the problem, I was trying to create a test case:
>>>>
>>>>User has ability to type whatever number of zipcodes for selection criteria, as he/she pleases. My Criteria Form creates a serious of inlist, if the number is less than some max_number (property of class). I currently set it to be 72, so there would be 3 inlists e.g. inlist(zipcode, code1,code2,..,code24) or inlist(zipcode,code25,...,code48) or ...
>>>>If the number is greater, I create a temp table and join to it, so this increases number of joins by 1. This seems to be executed too long, so I'm thinking, what could be reasons for this long execution and would I gain improving in perfomance, if I increase my max_number and would use more inlists, 5, in this particular case...
>>>>
>>>>However, I postponed these tests due to my manager told me, that we probably would implement Data Warehouse for One-time jobs too...
>>>
>>
>>In my form I have a check for number of joins, so I would not allow to save it, if the limit (9?) is reached.
>>
>>>Just an FYI. You may be reaching a limit with the number of joins. But, just wanted to ask if you've created an index on ZIPS for the temporary table.
>>>
>>
>>Yes, I have an index on btcCode in this temp table. It doesn't make a difference, though...
>
>All joined out, I guess
>
>>
>>>As you say, the issue may be passé.
>>>
>> Is it a French word? What does it mean?
>
>Yeah. I guess the closest translation would be "out of fashion" with a bit of a "tsk-tsk" in attitude. I added it because it rhymed with "say" and I wondered how I could get the accent in HTML <g>.
>
> Jay
It actually was my second question :) So, how? What font did you use?