Advertisement:

Author Topic: Keeping only 1200 listing  (Read 2525 times)

ShibLee

  • Newbie
  • *
  • Posts: 2
Keeping only 1200 listing
« on: December 18, 2016, 11:08:34 am »
Hello,
My classified site is keeping only 1200 listing. Rest of other listing is hiding or deleting automatically when new listing added.
How can I increase this number?
Please help.

_CONEJO

  • Administrator
  • Hero Member
  • *****
  • Posts: 4689
Re: Keeping only 1200 listing
« Reply #1 on: December 18, 2016, 11:57:19 am »
I guess you are talking about search page, where there's a 100pages limit, and the answer is to refine your search, no listing is being deleted, just not showing in the search results beyond page 100.

Due to how mysql (and databases works), reaching for page 100 takes way longer than page 1 and it takes way more resources too. Someone asking for page 1000 (thousand), could kill or hang your server, which is something to avoid.
It's a limitation, but, to be fair, nobody's going to go that further. Even google limits their search result (I think it was page 42 or something like that). Most people don't go further than page 2 or 3 with out redefining their search.