Site is slow

Bug Reports
1

Just want to feedback, lately Stockscafe seems very slow, not sure everyone has the same experience and whther anything can be done?

2

Hi there,

  1. Are you talking about first load of the day? Usually, the first loading after end of trading day is slower because it is processing new data. However, it should get better after you load it once.

  2. Is there a specific page that you are referring to? It will help me in isolating the issue.

Thanks,
Evan

3

Thanks Evan for the quick respose. It’s not the first load after EOD, it was the access to the site, I usually through saved favourate https://stocks.cafe/personal/portfolio,. Many time in the morning say around 9am+, I even get the cloud time-out error, but strangely today, it is very much faster, it was not as fast at all for the last one month or so. Another slowness I encountered was navigating through the tab, e.g. transactions, performance, dividents etc which I frequently did, it was slow before today, now it seems so much better, not sure if you need to do some reindexing or archiving which what we usually did in database.

4

It is usually not slow during this time.

Can you let me know again the next time when it is happening?

If you do @evankoh then, it will let me know via email and usually will get my attention faster.

I do not think the slowness is from DB. I do track the response time from DB and it is usually fine.

5

Wow…instant reply…lol…sure, thanks

1 Like
6

@evankoh Hi Evan, its slow now StocksCafe . The portfolio not showing up now, and can see the spinning thingy spins…for 2 minutes liao

7

Thanks. Looking at it. Found a few suspects. Will work on it.

8

@evankoh Site is slow again, error code cloudfare “A timeout occurred Error code 524”

9

Thanks. I restarted the server earlier. Should be fine now.

10

@evankoh Hi Evan, not sure anyone feedback before, lately the site has been very slow, it time out frequently at evening time, now is down, do check , thanks

image
image1200×956 42.7 KB

11

Initial investigation is that seems like increasing number of bots been crawling StocksCafe and slowing down the sites.

Yes, let me look into it more on how to reduce their impact.

12

It is really hard to use the site in the past couple of months.

I have a suggestion to limit the links available that the outside world can click on unless you create an account and login? That will reduce the surface available for crawlers to jump around on the site.

Or just increase capacity and pay your vendor more :money_with_wings:

13

Yes, good point.

Over the weekend, I intend to change it such that paying users will get a bigger server and non-paying and non-login users (including bots) will have a more standard server to interact. This is so that bots will not be able to slow down paying users.

14

For now, I am blocking all access of Stock pages by non-login users (mostly bots). Seems to be one of the key reasons for the slowdown.

If that still fails, then will block all access to Stock pages by non-paying users.

15

Thanks Evan, those could be DOS attack, I tot Cloudflare should took care of it, anyhow, I can immediately feel the different, hope stocks cafe gets better and better and we all huat together :+1:

1 Like
16

I did not set the settings in Cloudflare to be too strict because previously some users complained they kept being flagged as bot. It is a fine line :frowning: