Speeding up PHP?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux