What makes an application fast ? SQL optimization or elixir code optimization ?

[image] yurko: websocket instead of rest API (or graphql which will do less requests but they’re still requests) GraphQL can be done over ws as well. It does not enforce any transport. It only defines a language to query data.

[image] NobbZ: GraphQL can be done over ws as well. It does not enforce any transport. It only defines a language to query data. I actually thought about it, it would be a close to perfect API solution in my opinion

@younes-alouani : Here are my rules for you: Really well written code - think 10 or more times before you start work on it and make sure it looks clean - not only for you, but also for when you go back to project after longer time or anyone new. Less questions == better code. Spend time to write s…

[image] Eiji: Don’t use Elixir for anything. Do you mean everything there? :scream:

@Nicd : oops, thanks - fixed :smiley:

I’ve heard really good things about WebSockets. I’m hoping to make a web application that uses them one day :slight_smile:

[image] younes-alouani: What makes an application fast ? SQL optimization or elixir code optimization ? Did you mean to limit the discussion between the two? Because this thread is all over the place, as it would be with a very broad topic. If you meant to ask where to put your efforts, in …

[image] younes-alouani: What makes an application fast ? One thing makes code faster, universally, is doing less work. There are many areas where this applies: Finding a database record by taking a couple steps through an index vs rummaging through the entire table Loading a small image to …

Optimizing web apps can be an arduous job. Not only are web apps split in client-side and server-side components, but they are also usually built using diverse technology stacks: there’s the database, the backend components (which are usually built on a stack of different technologies as well), the …

My general best 5 here: First look at perceived performance, most of low hanging fruits can be found in the Frontend/Rendering part Following the previous, optimise outside in, with API/Backend/Database being very important but to be looked at after the Frontend and its requirements have been anal…