Re: Classifieds page loading is to slow

2021-01-16 Thread Ram
Thank you, Benny. We will try it and let you know. On Sat, Jan 16, 2021 at 5:48 PM Benny M wrote: > Ram, > These are all pieces to a puzzle. Indexing, ORM optimization and through > tables all add up to an efficient page render. Additionally, you could > consider caching some of your results, us

Re: Classifieds page loading is to slow

2021-01-16 Thread Benny M
Ram, These are all pieces to a puzzle. Indexing, ORM optimization and through tables all add up to an efficient page render. Additionally, you could consider caching some of your results, using a key like ‘postal code’ - some sort of constant that you could use as a metric/pivot. Use a cron job

Re: Classifieds page loading is to slow

2021-01-16 Thread Ram
Hi, We have a similar type of challenge in our project. We will definitely try indexing. Basically we are currently doing like this. 1. Registered users can post an ad in Classifieds by uploading 4 - 6 images per ad. All the ads are placed in one postgres db table. (classifieds table) 2. Same u