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" <george.pitcher@ingenta.com> wrote in message AMEPJAJDOFCDLPGFDOIFEEDDCLAA.george.pitcher@ingenta.com">news:AMEPJAJDOFCDLPGFDOIFEEDDCLAA.george.pitcher@ingenta.com... > 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
