February 8th, 2000, 10:29 PM
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.
February 9th, 2000, 09:33 AM
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.