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

[Joel Shapiro]

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