1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 1999
    Rep Power

    I, writing a script that lookup a record with a lot of field.
    The first page will show minimum information about that record until one click on a "detail" like that would open another page with more details.

    I know of to way of doing it.
    1. read all the record from the first query and passe the information as variables to the detail page.
    2. read the minimum fields with the first page, passe the same key to the other page that would re-query the database and return the "detail information.

    I'm looking for information on the adantage of one over the other and what make more sense as a server perforance stand point.


  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    From a server performance standpoint it would be better to do 1 query on the original page and pass the info to the second page. However, this is much more difficult to incorporate, especially if you return a result set and presenting the "minimum" information of several records. If you aren't expecting ebay like traffic you are surely safe with the extra query.

Similar Threads

  1. Insert query will not execute
    By MrTee1 in forum MySQL Help
    Replies: 2
    Last Post: February 11th, 2004, 06:38 PM
  2. variable variables problem
    By gbow in forum PHP Development
    Replies: 5
    Last Post: February 10th, 2004, 10:04 AM
  3. php variable issue
    By durilai in forum PHP Development
    Replies: 1
    Last Post: February 9th, 2004, 09:47 PM
  4. Return a single variable from query
    By dbr1066 in forum PHP Development
    Replies: 4
    Last Post: February 2nd, 2004, 01:42 PM
  5. Replies: 8
    Last Post: January 29th, 2004, 11:45 AM

IMN logo majestic logo threadwatch logo seochat tools logo