Build Multilingual Websites with Gridbox

Build Multilingual Websites With Joomla Website Builder Gridbox
Mon. - Fri. 9 am - 5 pm Ask a Question
Remember me

zero app filter peformance with category view

1 week 6 days ago #1

  • BiLe's Avatar
  • BiLe
  • Posts: 232
Hello,

my question is about zero app filter with category view.

From what I have seen, you are saving filter fields in one database column - which makes sense since number of fields can vary. I assume, zero app filter does not use an index when filter is applied and the filter results might take some time with e.g. 1 Mio+ items?

I am asking, because I am planning on using the zero app structure to hold my records, but a custom view + custom indexed tables for frontend category view.

1 week 6 days ago #2

  • Artem's Avatar
  • Artem
  • Posts: 9412
Hello,

Filtering 1 million items :blink: . Yes, it will take some time, probably the server will be down. :whistle:

We have tested on real site ~ 17 000 items, working fast, filtering takes 1-2 seconds. I can only recommend dividing Zero App to do not place 1 million items to 1 app

Regards,
Artem, Balbooa.com
Powered by Kunena Forum