Same deal with me

They must be using the same hosting company as ecigexpress.

And of course here I am thinking...I can throw a lot of crap in that box and find it pretty quickly. But, as you said, I'm a DBA

Nice analagy cheddar - nailed it

Almost definitely on the query side considering the actual payload takes about 200ms to download (similar timings on other assets such as css and JavaScript), but about 7 seconds elapse for me between the time the request is sent and the client downloads the payload of the main HTML request. Not necessarily as easy as simple traditional SQL query optimization and tuning though.

A lot of DAL stuff in modern web stacks is facilitated with ORMs not only for CRUD, but also database design (i.e. code-first model generation). Unfortunately these frameworks let devs run with scissors. When I have to do "query optimization" at work I see all kinds of terrible stuff such as entities without properly defined relationships that lead to a physical model schema void of important indexes and constraints. Also, devs get lazy and pull way more info than they actually need (maybe another query pulls the data they need so they just use it, despite it pulling in more entities than are required), and often under-utilize views for readonly content. The fix often involves no SQL tuning, but rather proper configuration of the frameworks.

EDIT: I'm not saying the devs behind ATF are doing these terrible things that I mentioned, nor am I saying that it's not something that a DBA would fix. I am simply stating that a lot of modern web applications are built by full-stack developers using frameworks whos' proper setup, and configuration is essential for long term performance.

I just mixed another 500mls of the stuff when the page eventually loaded to celebrate!

What other flavour of yours do you recommend?

Thank you mate! All that I ask is that you keep us updated :). As another user said, everything is fine apart from the recipes - especially the older ones. God's Milk just gave me a 500 error so the problem is still there :(

Thanks! The link takes about 5 secs to open now. I will let you know if it happens again.

Seems to work for me now again! Not getting the database errors and even if I load multiple recipes, they just load instead of returning errors. So at least from this side of the world (NL), it works fine again! Happy yearly subscriber again : ).

That is odd, this means it has enough head room to perform. But unfortunately for me it has been the same. Time out errors every two recipes. Very slow loading of all recipes. I pay for the service as well, and I’m really thankful for what you’ve build. But it’s rough atm. It looks to be specific to the recipe database, flavours seem to load relatively fast.

I’m new to the scene and to the website, but I’d rather pay for a website that looks good than a free website that looks like it was designed in 1998 and never updated. Still got love for ELR though, but ATF looks modern and got some great functionality.

What does the logs say? When I encounter the error, it says to check the logs :)

I can't imagine that someone would be throttling bandwidth on you, so I'm guessing there's some glitch in the query formation, something intermittent.

It's a single dude's passion project, not run by a company. And the amount made from ads and subscriptions is not impressive in any way. Unfortunately, that doesn't feel like a suitable excuse for the performance issues his site has had as of late.

I think it is a single guy building the site, not a company. He is on Reddit so hopefully someone can tag him in this thread.

I bet that's hella fast

Exactly what I was getting.

Because I joined when it was just released and I wanted to support the developer. As you know the site is free to use, but the dev needs to make money!

And it never used to be like this :(. It used to be amazing!

Some people like balls.