[FX.php List] Value lists or Data (FMView or Mult. Queries)

Dale Bengston dbengston at preservationstudio.com
Thu Nov 2 17:57:00 MST 2006 

Depends on how you look at it, I guess. Works smashingly well for me.

I don't know about the portal stuff. I try to stay away from related  
fields on web layouts. It's an old v6 habit.

Dale

On Nov 2, 2006, at 6:37 PM, Bob Patin wrote:

> That seems like way too much trouble! :)
>
> So many of the databases I use for web sites perform double duty;  
> so often I have to work with databases that were designed for use  
> in an office and not for the web.
>
> So here's a question: when you do a query of a table, and the  
> layout has a portal on it, does all of the portal's contents get  
> returned in the results array?
>
> The reason I'm asking is this: if that's the case, then I've been  
> doing 2 queries in a lot of places where one would've done the  
> trick... :)
>
> Does having a portal like this on the layout slow things down? I  
> would think it would...
>
> Here's what I'm wondering: isn't it just as fast to do 2 queries of  
> 2 unrelated tables, where each layout has only the fields needing  
> to be returned, rather than querying one layout that has a portal  
> on it?
>
> Or have I been thinking about this wrong? :)
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
>
>   CONTACT US VIA INSTANT MESSAGING:
>      AIM or iChat: longterm1954
>      Yahoo: longterm_solutions
>      MSN: tech at longtermsolutions.com
>      ICQ: 159333060
>
>
> On Nov 2, 2006, at 6:25 PM, Joel Shapiro wrote:
>
>> Hi Dale
>>
>> That's interesting...  So you just have one ValueLists table, and  
>> to pull the "States" value list (for example) you'd query that  
>> table for VL = 'State', right?
>>
>> But then what do you do in the FMP interface?  Do you use globals  
>> to pull the appropriate/related values into the value lists?  So  
>> if I have 6 value lists on my FMP layout, I'd need 6 globals, each  
>> w/ its own relationship to the ValueLists table?
>>
>> Also, I've heard people here discuss overloading session  
>> variables, but I have no idea how much would be too much.  Do you  
>> think storing 6 more session arrays w/ these value lists is OK?
>>
>> Thanks very much,
>> -Joel
>>
>>
>> On Nov 2, 2006, at 4:06 PM, Dale Bengston wrote:
>>
>>> Hi guys,
>>>
>>> I use option C as well - store the data in a lists table and  
>>> query it to make value lists. Some advantages:
>>>
>>> 1. It's easy to set up a key & value pair for the value list,  
>>> where the key is the id and the value is more human readable  
>>> data. So you're storing the key and displaying the more friendly  
>>> information to the person using your system.
>>> 	C10001 => Bob
>>> 	C10002 => Joel
>>> 	C10003 => Dale
>>> 	C10004 => Gjermund
>>> 	...
>>>
>>> 2. I can have other fields in my list table to sort on, besides  
>>> the actual displayed values.
>>>
>>> 3. The first time I need to use that list, I make the query and  
>>> store the data in a session array, and then I can reuse it  
>>> subsequently without having to query again.
>>>
>>> Dale
>>>
>>> On Nov 2, 2006, at 5:39 PM, Joel Shapiro wrote:
>>>
>>>> Hi Bob
>>>>
>>>> I'm not sure what you mean about querying one table twice -- why  
>>>> would you need to do that?
>>>>
>>>> What I was referring to is that having multiple queries on one  
>>>> PHP page is (reportedly) slower than having only one PHP query,  
>>>> and returning related data via related fields (w/ or w/o  
>>>> portals) on the one queried layout.  For instance, having a  
>>>> portal of Child records on a Parent's layout, and then just  
>>>> querying the Parent records, is faster than querying the Parent  
>>>> records and querying the Children records separately.
>>>>
>>>> -Joel
>>>>
>>>>
>>>> On Nov 2, 2006, at 3:25 PM, Bob Patin wrote:
>>>>
>>>>> Is there any difference between querying one table twice and  
>>>>> querying 2 different tables once each? I'm asking because I  
>>>>> can't imagine that there would be any speed difference...
>>>>>
>>>>> I have a lot of pages where I do multiple queries; I've never  
>>>>> done any comparative testing though. It would be fairly  
>>>>> difficult to do a fair test, unless it were on a local network  
>>>>> that's not influenced by Internet fluctuations. My hosting  
>>>>> company network, which has 30 servers in it and almost 200  
>>>>> websites and 150+ databases, fluctuates a good bit depending on  
>>>>> what's going on, who's downloading, who's updating sites, and  
>>>>> so on.
>>>>>
>>>>>
>>>>> Bob Patin
>>>>> Longterm Solutions
>>>>> bob at longtermsolutions.com
>>>>> 615-333-6858
>>>>> http://www.longtermsolutions.com
>>>>>
>>>>>   CONTACT US VIA INSTANT MESSAGING:
>>>>>      AIM or iChat: longterm1954
>>>>>      Yahoo: longterm_solutions
>>>>>      MSN: tech at longtermsolutions.com
>>>>>      ICQ: 159333060
>>>>>
>>>>> On Nov 2, 2006, at 5:10 PM, Joel Shapiro wrote:
>>>>>
>>>>>> Thanks Bob and Gjermund
>>>>>>
>>>>>> I've got 6 value lists on one form.  I've started implementing  
>>>>>> my option A.
>>>>>>
>>>>>> I suppose, though, I could put portals (cartesian-join  
>>>>>> relationships) of each of the value-list tables onto my one  
>>>>>> layout so I wouldn't have to query the DB more than once.  At  
>>>>>> that point, it seems it would be pretty similar to pulling  
>>>>>> multiple value lists from the same one layout, and I wouldn't  
>>>>>> need to do a separate FMView -- only the one FMFind...  hmm...
>>>>>>
>>>>>> Good food for thought... though I'm not gonna do any benchmark  
>>>>>> testing on this one ;)
>>>>>>
>>>>>> Thanks all,
>>>>>> -Joel
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>
>> _______________________________________________
>> 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

More information about the FX.php_List mailing list