blog documentation FAQ followers forum marketplace services youtube

solved still slow sorts/page loads on seamless pages

The Jamroom Network » Forum » Installation and Configuration » Page » still slow sorts/page loads on seamless pages
soaringeagle
@soaringeagle
9 years ago
3,304 posts
pages like https://www.dreadlockssite.com/newest-photos
that use seamless lists and sort by _created highest rated or updated etc take a long time to load the 1st time its viewed
after 1st load it loads faster
but 1st loads very slow


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
updated by @soaringeagle: 06/26/16 08:28:28AM
michael
@michael
9 years ago
7,773 posts
the fastest way to order them will be by _item_id as its a primary key. That's also the default order so if you leave order off it should be quicker.
soaringeagle
@soaringeagle
9 years ago
3,304 posts
well true but i want a highest rated, and a newest posted lists too
is there any way to speed up the ordering in the db tables


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
soaringeagle
@soaringeagle
9 years ago
3,304 posts
yikes try it in chrome i get all asci characters


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
brian
@brian
9 years ago
10,148 posts
soaringeagle:
well true but i want a highest rated, and a newest posted lists too
is there any way to speed up the ordering in the db tables

No - if you want speed on these lists, do not use Seamless. It's already optimized as fast as it can go.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
9 years ago
10,148 posts
I should add that there is some DS optimizations coming in 5.3.4 that might help you a little bit (as it deals with results optimizations from very large search item calls, which Seamless uses) - so after 5.3.4 see if it gets better for you.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
soaringeagle
@soaringeagle
9 years ago
3,304 posts
ok thanks


--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities

Tags