You should try to have MySQL organize the data for you. Since you are using Dreamweaver to generate your code, your SQL knowledge may not be up to it. But there are a number of query options. Perhaps if you posted your table structure and the result you are looking for, the list could help with a query.
Even though everything is on one machine, you still needed to do lots memory transfer from MySQL to Apache/PHP. The difference may not be noticeable, but I would always try to design for scalability. MySQL is designed to handle data so I would let it.
On Sep 8, 2004, at 11:28 AM, Robb Kerr wrote:
Here's the scenario...
First, my HTTP Server (Apache), PHP Server and MySQL Server are on the same
machine - an Apple Xserve.
Second, I've got a page with a long repeat region reflecting a recordset
queried out of a MySQL table. The region also displays information obtained
from fields in a related table.
Third, I use Dreamweaver to generate my MySQL recordsets and repeat regions.
Here's the question...
I can either A) in the header or my page, generate a recordset of all of
the records in the related table and then loop through the recordset
creating an array of the fields I need and then later pull from it in the
repeat region... or B) take the six lines of code Dreamweaver generates to
create a recordset and move them into the repeat region itself. In other
words, I can create a recordset of all of the records in the related table,
loop through it generating a PHP array and pull from this array later OR I
can query the database every time through the loop while creating the
repeat region.
Since I haven't freed the table until the bottom of the page and because my
MySQL Sever and PHP Server reside on the same machine, will I really notice
a measurable difference in speed? If my MySQL Server were a different
machine, I'm sure that there would be a noticable difference because all of
the queries would be across a network (possibly the internet) and traffic
would become a factor.
Just wondering what other people have noticed. BTW, I've also posted this
on the PHP board.
Thanx -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams ---------------------------------------------------- http://www.digitaliguana.com http://www.cancerreallysucks.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
