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
