Slow site - need tip - PHPBuilder Forums

Slow site - need tip

Lucifix

Hi everyone,

I'm having problem that I don't know how to start solving it.

My site starts loading very slow. At first I thought that this is host problem, but now I have moved to another host, which should be much faster. But that didn't help it.

Then I start thinking that I have problem in my code. So I start measuring time at the very first header and at the bottom of the page (footer).

$today = date("H:i:s");

The difference between header and footer was only 5 secunds. So I figure it out that you have to wait over 20 secunds just to start loading PHP code

Please I could use any tip to improve speed.I'm using PHP and SQL.

http://www.slo-foto.net
Slowest: http://www.slo-foto.net/galerija.html

Thank you!

vaaaska

It's probably your query. You should post the contents of the full page (with PHP).

Lucifix

I don't understand why query might be the problem, becouse all queries loads withing 5 secounds.

As I said I start measuring at start when no queries starts.

Can it this be a problem (image included)

Weedpacket

Five seconds is way too long. Unless you're doing something seriously massive or the server is under seriously heavy load a page should be processed in well under a second.

In five seconds I could (and just did) read a 200kB file into memory and compute its MD5 hash over 1500 times.

If it is the database (which it might well be, if you start timing before your first query and stop timing after your last), I've got a database here in which one table contains 2,539,913 records. In a quick test I did just now, in nine seconds I can count the number of records in the table, find the average of two fields, and the top ten values of another field. So unless you're dealing with millions of records....

As for that image; all I can make out from that is that there is some program that is suggesting that there is something wrong with your database design.

Lucifix

My database takes over 300MB (I don't know if that's big for you), but if I count 2,201,892 records...
Showing rows 0 - 29 (2,201,892 total, Query took 0.0348 sec)

If I sum them it takes cca 10sec.
Showing rows 0 - 0 (1 total, Query took 10.6430 sec)

Maybe my answer is not even close to what you wrote, so please excuse me, couse I'm still newbie...

ClarkF1

Well it's probably not helping that you have two lots of <html> <head> and <body> tags etc. in each page.

The second lot start just after the coding for the menu so it suggests a problem with a include perhaps.

MarkR

Have you benchmarked it exactly on your local dev server? Have you tried adding instrumentation to have ad-hoc profiling?

You may also want to consider using a PHP profiler, there is at least one available, APD. This will tell you how long is being spent in each function during the execution of the page.

You can then concentrate on improving the performance of slow bits and ignore the fast parts.

If all the time is being spent in database queries, you may want to improve these by adding indexes as necessary, or restructuring your database to enable these queries to perform more optimally. The latter may require major refactoring.

Incidentially, summing 2 million rows in the database is probably not something you should do on every page (nevertheless, you'll find that provided they don't change too often, MySQL's query cache should make this perform much better than you'd expect).

Mark