just for your information, when im use in localhost this issue doesn't occur, the time taken to load the data only 1 sec meanwhile when I'm deploy the project in windows server the same data take 20 sec to load

Hello @lhakim12

It can be multiple things like by example:

1. Is de database on the same server or another? And if it is on another server how is the connection between those servers?
2. Does the server has enough resources?
3. Is there a firewall or something else that takes a lot of time to let the traffic flow?
4. How do you connect to the server?

Did you any measuring to find what makes the application slow? (Memory, filesystem, database, network itself)

Ps. Windows Server sounds like you try to run xampp in production. If I read the faq that is not advisable. See: https://www.apachefriends.org/faq_windows.html

Is XAMPP production ready?
XAMPP is not meant for production use but only for development environments. XAMPP is configured to be open as possible to allow the developer anything he/she wants. For development environments, this is great but in a production environment, it could be fatal.

Can you configure the slow queries log? How much memory and how many cores does the server have? Because sometimes the issue is not on the MySQL side.

Hello @tvbeek first of all thank you for replying my thread regarding the problem I'm facing. based on your question,

1. The database on the server, I download xampp, run the apache and MySQL and run my project in the vs code there. i run my project by using this command "PHP artisan serve --host=0.0.0.0" in the terminal inside the vs code.

2. I don't know how to answer this because someone else setup the windows server, I just access/remote the PC by using anydesk from my own laptop. p/s the person that setup the server have zero knowledge about laravel.

3. I'm not sure about this, cause I just paste my whole project there. what I use in my own laptop during development phase. the same thing I use in the deployment phase. the different just in localhost host I run the project using "PHP artisan serve" command, and in windows server I run the project using "PHP artisan serve --host=0.0.0.0".

4. remote using anydesk from my laptop

I don't know how to find the problem what makes the application slow.

yes, I'm trying to use xampp in production because I have zero knowledge about deployment. I'm only know about development only. i think this might be the cause to the problem that I'm facing. did you have any idea how can I overcome this?

thank you.

hi @edulazaro based on your question,

1. did you means check the data loadtime using something like clockwork when you ask about configure the slow query log?

2. the memory for the server is 16gb for ram and 4 core 2.3ghz for processor