Delay in loading PHP page with image

Question

I have a PHP page that loads the 570 records in 2 seconds.

The problem is that when I insert images, even small (3 KB) the charging time goes to 10 seconds.

Is there any way to upload these images?

    <?php 
    while($consulta1 = mysql_fetch_array($result1)){;  
    ?>

    <div class="relacao">
      <div class="nome-album-artista"><?php echo $consulta1["nm_album"].'<br><i>'.$consulta1["nm_cantor"].'</i>'; ?></div>
    </div>

    <div id="botoes">
      <div class="btn_alterar"><a href="album_alterar.php?album=<?php echo $consulta1["id_album"]?>" title="Alterar"><img src="images/valid-icon.png"></a></div>
    </div>

    <?php
    }
    mysql_free_result($result1); 
    mysql_close($conn)
    ?>

Answer 1

You may not find the solution to your problem here, as it is a very different case that addresses many theories about networks, memory, etc.. So delete all possibility the problem is in your code.

However, I’d like to introduce Yslow as ANSWER to your question. It offers suggestions to improve the performance of the page and summarizes the components of your page.

Yslow analyzes web pages and why they are slow. Made for high performance websites.

Download: http://yslow.org/

Source: https://stackoverflow.com/questions/1559355/how-can-i-speed-up-image-load-time-in-my-web-site

Answer 2

One more possibility for you is to upload the images only when they are really needed. A project called Lazy Load (jQuery) does just that. It will cause the images to be loaded only when they are in the user’s viewport.

Project website:

http://www.appelsiini.net/projects/lazyload

Answer 3

Before trying to optimize, need to know what happens.

In the case of PHP and Mysql (the other BDD), we have 4 points:

1. treatment time on the BDD side
2. PHP side processing time
3. data transmission time between server and browser
4. time of page construction by browser

For point 1 vc can check using this:

 $start_time = microtime(true);   // Antes
 $result = @mysqli_query($handle,$query);
 $end_time = microtime(true);   // Depois
 $ecart = $end_time - $start_time;  // Diferença

For point 2, you can do it the same way: put a microtime(true) at the beginning of the PHP page, one at the last line, calculate the difference and make an "echo" of the result.

After that, you will be able to see if the exposure time is identical to that of the calculation: if the time of "PHP" is 0.03 second, the Mysql time of 0.01 it takes 3 seconds to see the page, it means that the problem does not happen in Point 1 or in Point 2...

About Point 4, there is one thing to know: I don’t know the structure of your page, but the browsers start showing the contents of the pages with tables, only after receiving the whole code. For example, if you have 500 results (after the query) and you put the results in one table (then you have the TABLE tag at the beginning of the page, then 500 TD and TR tags for the 500 results and at the end of the page the TABLE lock tag)The browser will expect to receive the 500 data BEFORE starting to show anything. To avoid this, you need to open and close the table, for example every 30 results. Thus, the user will quickly see the first 30, when the other results will continue to arrive. This will not change the "real" time but will change quite the perception of time!

Last chance: your internet connection is weak.

PS: a detail. "mysql" module is considered obsolete. Need to use mysqli.