Slow execution....

[alquimista]

Hi,

I uploaded a small test application; it consists of a list of records (using DBRepeater), and a form to maintain each one's data.
Both forms inherit from a MasterPage that contains a logo, some header text and the MainMenu component.

When I was developing it, it took sometime to execute and I though it was because of the IDE and debugger stuff; now in the "production" web hosting... the execution it’s very slow: it takes 5 to 6 seconds to show 11 records Maybe it is because for each one, the "view", "delete", "change" icons are loaded per record? Those images were placed on the "BeforeShow" event of the component.
On column labels, I have links to sort the list on that column; it takes up to 8 seconds to sort and display... If I'd had 100 records, my user will be a bit mad on these execution speeds...

By the way, using IE 6 it takes less than in FF 3.

If those records where shown in a simple HTML table, it'd take less than a second to show them.

You can see the actual example here

What is causing these delays?

Thank you,
Guillermo

[405hp]

It is all relative. You are using a large amount of file transfer

Documents (1 file) 123 KB
LyR - Lista de Bancos 123 KB
Images (6 files) 4 KB
http://www.gnsis.net/test/imagenes/GNW_Logo%2001.jpg 3 KB
http://www.gnsis.net/test/GNsis/imag...ction_edit.png 411 bytes
http://www.gnsis.net/test/GNsis/imagenes/search.png 391 bytes
http://www.gnsis.net/test/GNsis/imagenes/action_add.png 288 bytes
http://www.gnsis.net/test/GNsis/imag...ion_remove.png 195 bytes
http://www.gnsis.net/test/vcl/images/pixel_trans.gif 43 bytes
Objects (0 files)
Scripts (4 files) 983 KB
http://www.gnsis.net/test/vcl/qooxdo...k/script/qx.js 934 KB
http://www.gnsis.net/test/vcl/walter..._jsgraphics.js 23 KB
http://www.gnsis.net/test/vcl/compon...ult/scripts.js 20 KB
http://www.gnsis.net/test/vcl/js/common.js 5 KB
Style Sheets (2 files) 927 bytes
http://www.gnsis.net/test/vcl/compon...hemestyles.css 496 bytes
http://www.gnsis.net/test/vcl/compon...linestyles.css 431 bytes
Total 1111 KB

It takes about 7 seconds the first time in ie7.
Things you can do to speed it up.
don't use a couple of small qx controls if they can be replaced by html ones - once you have a big qx control then it makes no difference.
set you server up to send the files compressed. VCL for PHP :: View topic - Speed optimizations

use ajax especially the basic ajax to improve responses http://forums.delphi-php.net/ajax-ja...jax-d4php.html

Do more of your stuff in the browser w/js and in the same form.

Don't use so much inheritance and extra load times in the php. - not sure how much time this saves.

Both PHP and JS are interpretative languages Every time it loads it must re-interpret every line of code.

[alquimista]

Thank you 405hp !

[alquimista]

405hp,

I tested the compression option in php.ini with:

zlib.output_compression = on
zlib.output_compression_level = 8

The difference its important; at least 50% time response improvement

Thank you!

Guillermo

[takaya]

remove these code in php.ini

[Debugger]
debugger.enabled=on
debugger.profiler_enabled=on
debugger.JIT_enabled=on
debugger.JIT_host = clienthost
debugger.JIT_port = 7869

[alquimista]

Thank you Takaya ! now the app runs even faster