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

[Bob Patin]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20061102/8716d219/attachment-0001.html