A bit slow to view gallery

[kenhirai]

i have around 200,000 galleries in database now but when I view gallery with no cache, its taking around 8 - 10 seconds to connect. tag/search/list pages are faster. only galleries, is there anyway to optimize the speed, i did all the mysql tuning and install reddis. its just pulling from gallery it takes a bit longer without cache.

[admin]

Try to convert table rot_content into innodb.

[kenhirai]

well I convert them as u said, but seems like its even more slower, now it takes a really long time, around 20 - 30 seconds to open a gallery

[kenhirai]

images are loading very slow too

[admin]

Images = static content
Script does not affect it.
Ask admin to fix image loading speed first.

[kenhirai]

Images = static content
Script does not affect it.
Ask admin to fix image loading speed first.

but it takes a long time to even load the gallery first.

at least 10 - 15 seconds to open the page.

the situation is

search page - 3 - 5 seconds
list page - 5 - 6 seconds
gallery page - 10-20 seconds

this are tested without cache. I have done the switch of rot_content to innodb, but still the same slow. any other ways to improve the speed of opening up gallery page.

[kenhirai]

Ok I have conducted a test and find the cause of why its very slow. Because I use alot of related galleries in content page, it takes a long time to open up the page. when I dont use any relate gallery, its super fast.

problem,

how to speed up connection when a content page using a lot of related galleries beneath using relevant tags.

[admin]

So static content loads fast now ? what have you done ?