Page 1 of 1

Slow dynamicaly created pages.

Posted: Tue Jun 24, 2003 6:23 am
by Deddog
Hello,
I have recently designed an intranet(PHP) that relies heavily on mysql databases.

At some stages there are 3 pages being simultaneously dynamically created from a DB and then displayed in iframe’s. This causes the main page to load in any thing from 2 to 9 seconds.

If have recently re-written all my select statements and have started to include “mysql_Close()” after all selects are made.

I imagine the slowness is caused by having 3 select statements hit the server at once.

Is there any way I can improve on the loading speed or is there some tweaks I can make to the server?

Posted: Tue Jun 24, 2003 6:33 am
by []InTeR[]
Are you only selecting what you need?
Do you have the right index'es on the database?

Posted: Tue Jun 24, 2003 7:11 am
by Judas
Manage your data with session vars.
Display it with Js or DOM.
(maybe XML)

thanks 4 the help

Posted: Wed Jun 25, 2003 3:31 am
by Deddog
InTer and Judas,
many thanks for the replies.

Recently amended my SQL statements to only select data needed. Also adapted statments to incorporate LEFT JOINS, thus making other functions and select statements redundant.

All the tables have the PRIMARY KEY set as an index.

Not quite ready to delve into the world of XML just yet, but thanks for the sugestion.

Loading times are now at approx 4 seconds.

Any idea's how this can be improved on or is this an ok loading time?

Thanks in advance

Deddog.