I never thought of the return only the query"ing" part. My predicament is I have a search form that queries a table with about 7 joins. It returns it via a Dreamweaver recordset aka SQL query. So based on what you said below , regarding the number of users, this is a bad way to go.
Stuart --- Brent Baisley <[EMAIL PROTECTED]> wrote: > 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]