Andrei, Thanks for the tip. I've now 'paged' it and the results are fine.
Cheers George > -----Original Message----- > From: Andrei BEJENARU [mailto:[EMAIL PROTECTED] > Sent: 28 October 2003 4:52 pm > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] Re: Speeding up PHP? > > > First of all, you should break the results into chunks getting > 20-30 results > at a time. > A page displaying 1275 result is anything but readable. > Use LIMIT in your SQL query and create a navigation bar. > Also use indexing of the columns and filtering (WHERE conditions). > > --- > Andrei BEJENARU - Developer > InterAKT Online > http://www.interakt.ro/ > Tel: +4021 312.53.12 > Tel/Fax: +4021 312.51.91 > > > "George Pitcher" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi, > > > > I've started redesigning a website that is currently running using > > Filemaker/Lasso. The new site will by PHP/MySQL. > > > > I'm in the early stages but I've been doing some basic tests and I'm > > disappointed with the speed of PHP in building the web-page. > I've set up a > > SQL query which takes 0.89 secs to complete in MySQL (using MySQLFront) > but > > the same query takes 15 seconds to build the page (1275 results out of 2 > > tables, the largest of which containns 62000 records). > > > > This particular search is concerned with bibliographical data. > > > > After PHP processes the query, I do the following: > > > > - mysql_num_rows - to show how many hits there were > > > > - For each row, > > > > - - read field data into variables > > > > - - perform a function to build a pagerange string for display > > > > - - build the table row to contain the data > > > > I've preset the widths of the columns to a percentage of the page width > the > > reduce the amount of calculating required by the browser (IE 5.5 in my > > case). > > > > Does anyone have any tips to help speed this up for me please. > > > > By the way, the same search on the current web-site took 63 seconds to > > produce the web-page. > > > > > > George in Oxford > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
