Remember me

zero app filter peformance with category view

2 years 3 months ago #1

  • BiLe's Avatar
  • BiLe
  • Posts: 324

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.

2 years 3 months ago #2

  • Artem's Avatar
  • Artem
  • Posts: 11342

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

Powered by Kunena Forum