Hey all! Firstly a huge thanks in advance to anyone who spends time responding to this.
So I’m working on my MVP which I’m about to launch (in its simplest form this is an AI based news aggregator)
To date my server set up has been:
-
data storage, scraping, and app API calls to my digital ocean server. This is a 2GB memory, 1 AMD vCPU 50 GB disk server running LAMP on Ubuntu 20.04
-
All my AI LLM work where I preprocess and clean text, locally run LLMs from hugging face is done through a Scaleway PLAY2-PICO instance.
A few issues I’m facing:
-
The api calls to the digital ocean server are incredibly slow. Takes 5 seconds to load posts and I’m the only one using the app.
-
The scaleway server processes for LLMs just get killed I assume due to memory issues or whatever it is.
So now to the question. What is the server architecture / providers you guys use? It needs to be able to deal with large data tables in MYSQL quickly as well as run large LLM models as well (the two don’t need to be the same set up)
Much appreciated!
As u/victrolla said you need to do some profiling, but I suspect it’s lack of indexes in your SQL database tables.
Thanks! Sorry for the noob question but what would you need to know as part of the profiling?