Version 2.5 first page creation gives timeout.

[halohool]

Hi,

When I changed number of videos from 2000 to 3000 generating the index.php page (home page) usually gives timout and internal server error since it cannot finish generating the page. But, if I cut number of videos it works. What is that too CPU or DB intensive in the first page? All other pages work fine. By the way, I am using version 2.5

Thanks.

[admin]

Hi,

When I changed number of videos from 2000 to 3000 generating the index.php page (home page) usually gives timout and internal server error since it cannot finish generating the page. But, if I cut number of videos it works. What is that too CPU or DB intensive in the first page? All other pages work fine. By the way, I am using version 2.5

Thanks.

Where you changed 2000 to 3000 ?

Are you saying you are trying to show 2000 to 3000 video on home page ?

[halohool]

no I mean when I increased number of the approved videos from 2000 to 3000 videos it takes longer for index page to generated. I just show the first 6 latest videos and 3 recent watched one. I guess generating "Recent Tags" column is not efficeint and scalable. I decreased size of the "keyword" field of the database and this could speed up generating the main page. Is there any way you could optimize the piece of the code that makes the "Recent Tags" in the homepage?

Thanks.