Local JSON file vs MySql database I've built a website using node js and it has two parts. one for users and one for website administrators for editing content on website that is locked by a login page. The user side, loads data from local json file and administrators side, loads data from mysql database.
I want to know is it better to use mysql on both sides for increased performance?
I am new in programming and I'm a bit confused between mysql Connections and Pools. Which one is better for performance if I have a lot of users receiving data?
this is the function for receiving data:
function getAllProductsLocal() {
    try {

        const products_json = JSON.parse(fsExtra.readFileSync(&quot;./public/assets/JSON/products.json&quot;));
        return products_json;
    
    }catch(e) {
        throw e;
    }    
}

and this is an example of the data I'm storing in JSON file:
{
    &quot;ID&quot;: 19,
    &quot;Cost&quot;: 212,
    &quot;Sizes&quot;: &quot;[4,7]&quot;,
    &quot;Category&quot;: &quot;man&quot;,
    &quot;Color&quot;: &quot;blue&quot;
}

there will be a hundred of them
The question really depends on what kind of querying of the JSON data you're doing, but I suspect if your data grows large enough (or when your use cases become complex enough) you'll find the file processing operations you're doing with fs-extra will be outperformed by the equivalent operations in a database, such as MySQL, especially because you mentioned the JSON file is accessed remotely since it's stored on the server, rather than the client's end.
I think local JSON files are good on the client's end for simple things like user app settings and user preferences, and fine to store on the server for basic things like the navigation menu's structure of the website, for example. But I wouldn't plan to store the main data of the application in a file, rather you'll likely be better off storing it in a database.