The end result will be the same, it's just a matter of the structure
the data will have when handed to PHP for processing to display. It can
be retrieved bit by bit and broken up into multiple lists or joined and
summarized by MySQL into one list. One list will make the PHP loop
simpler, smaller and faster.
On Sep 8, 2004, at 2:12 PM, Stuart Felenstein wrote:
I'm confused about this response and am facing a
similar situation.
First, regarding the subject, what is the difference
between a PHP or whatever loop and a SQL query. All
the app code is doing is collecting the request and
handing it back to the database. The DBMS still has
to retrieve the data.
My only guess is that the DBMS has to work a bit
harder, as PHP would present the data in a cleaner /
neater / parsed form back to the DBMS.
Any of this make sense ?
Stuart
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
I would try not to query MySQL on each iteration of
the loop. While a
dozen or so queries may not make a noticeable
difference, hundreds or
thousands may. It's not a scalable technique,
whether you need to scale
it or not. Even if it's only 100 iterations, what if
you have 10 people
accessing the database at once? That's now 1,000
queries.
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]
--
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]
