I assume he means selecting every entry in a given table ("select column
from table"). You should be able to easily find the answer to this by
inserting some code that records times as you run. My bets are on SQL.
Cheers,
Brian
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 10:49 AM
To: Peter Lovatt; Brent Baisley; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: What's Faster? MySQL Queries or PHP Loops?
I've been meaning to follow up on this post.
Can either Peter or someone expand and provide an
example of "get all information in a single query..."
Thank you ,
Stuart
--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> Hi
>
> What I do is to try and get all information in a
> single query and then use
> php from there on. I go as far as building arrays
> from result sets and
> manipulating the data using php.
>
> Can't guarantee this is best practice but I have
> built big sites with big
> visitor numbers this way and they run OK :)
>
> HTH
>
> Peter
>
>
>
> > -Original Message-
> > From: Brent Baisley [mailto:[EMAIL PROTECTED]
> > Sent: 08 September 2004 19:01
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: What's Faster? MySQL Queries or PHP
> Loops?
> >
> >
> > 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]
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.m
