Muhammad Idris Posted November 7, 2023 Author Share Posted November 7, 2023 12 hours ago, Farshad Mohajeri said: It seems that slow down occurs when peak request is above 300. It indicates that requests are coming faster than the speed system can process them. It can be the database back-end which is not able process too many concurrent requests as fast as it must be done. but why is it that when I divide the service into 3 hyperservers the application slowdown doesn't occur Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 7, 2023 Author Share Posted November 7, 2023 and if it's a database problem, actually there are many services that access the SQL Server database and when it's still under 200 sessions it's not a problem. We use SQL Server 2019 Enterprise Quote Link to comment Share on other sites More sharing options...
IRWANTO82 Posted November 8, 2023 Share Posted November 8, 2023 your .exe binary and hyperserver using win32 or win64 ? Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 9, 2023 Author Share Posted November 9, 2023 23 hours ago, IRWANTO82 said: your .exe binary and hyperserver using win32 or win64 ? Win32 Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 9, 2023 Author Share Posted November 9, 2023 On 11/8/2023 at 10:33 PM, IRWANTO82 said: your .exe binary and hyperserver using win32 or win64 ? .exe binary hyperserver 64 Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 11, 2023 Author Share Posted November 11, 2023 On 10/21/2023 at 1:13 AM, Abaksoft said: Can you update to Build 1573 Will upgrading to version 1573 solve the problem? and how many sessions in your application can be handled by the hyperserver? Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted November 11, 2023 Share Posted November 11, 2023 53 minutes ago, Muhammad Idris said: How many sessions in your application can be handled by the hyperserver? Salam Muhammad, I apologize for this. I didn't use til now hyperservers technic. As Farshad has done many improvment in the recent versions, i thought that it was OK. Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 13, 2023 Author Share Posted November 13, 2023 On 11/11/2023 at 6:12 PM, Abaksoft said: Salam Muhammad, I apologize for this. I didn't use til now hyperservers technic. As Farshad has done many improvment in the recent versions, i thought that it was OK. what technique do you use and how many sessions can it handle? Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted November 13, 2023 Share Posted November 13, 2023 2 hours ago, Muhammad Idris said: what technique do you use and how many sessions can it handle? - A simple Unigui as Service, HyperServer. - No more than 10 users I would have really wanted to launch a new project with 1000 users in real time and exploit farm server for load balancing (what you are currently using with your 3 servers) but my plan failed. Maybe you should review the structure of your program. - use frames that open and close. - Free up Dataset resources (RAM) immediately. - minimize size of exe file - use Pool connection to avoid braking RDB system _ etc... Quote Link to comment Share on other sites More sharing options...
55143681 Posted November 13, 2023 Share Posted November 13, 2023 On 11/6/2023 at 11:42 PM, Farshad Mohajeri said: It seems that slow down occurs when peak request is above 300. It indicates that requests are coming faster than the speed system can process them. It can be the database back-end which is not able process too many concurrent requests as fast as it must be done. On 11/6/2023 at 10:15 PM, Muhammad Idris said: If you are using mysql database,you need to card the "slow query problem", what means that if your sql operation on the field not be indexed, the query will be very slowly. Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted November 13, 2023 Share Posted November 13, 2023 2 hours ago, 55143681 said: If you are using mysql He is using SQL Server 2019 Enterprise. Quote Link to comment Share on other sites More sharing options...
picyka Posted November 13, 2023 Share Posted November 13, 2023 You need to have a good pool of connections in the DB, and analyze your qry to see if there is anything slow, I would recommend using the API. Quote Link to comment Share on other sites More sharing options...
55143681 Posted November 14, 2023 Share Posted November 14, 2023 18 hours ago, Abaksoft said: - A simple Unigui as Service, HyperServer. - No more than 10 users I would have really wanted to launch a new project with 1000 users in real time and exploit farm server for load balancing (what you are currently using with your 3 servers) but my plan failed. Maybe you should review the structure of your program. - use frames that open and close. - Free up Dataset resources (RAM) immediately. - minimize size of exe file - use Pool connection to avoid braking RDB system _ etc... MY project in my office network, about seventy users, a *.exe runs fast. Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 14, 2023 Author Share Posted November 14, 2023 On 11/13/2023 at 5:15 PM, 55143681 said: If you are using mysql database,you need to card the "slow query problem", what means that if your sql operation on the field not be indexed, the query will be very slowly. All of our tables have been indexed based on joined and frequently searched columns Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 14, 2023 Author Share Posted November 14, 2023 On 11/13/2023 at 7:34 PM, picyka said: You need to have a good pool of connections in the DB, and analyze your qry to see if there is anything slow, I would recommend using the API. If it's a connection problem to the database, why is it that when I divide it into 3 hyperserver services the problem is slow to resolve? which I have screenshot above Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 14, 2023 Author Share Posted November 14, 2023 On 11/13/2023 at 1:01 PM, Abaksoft said: - A simple Unigui as Service, HyperServer. - No more than 10 users I would have really wanted to launch a new project with 1000 users in real time and exploit farm server for load balancing (what you are currently using with your 3 servers) but my plan failed. Maybe you should review the structure of your program. - use frames that open and close. - Free up Dataset resources (RAM) immediately. - minimize size of exe file - use Pool connection to avoid braking RDB system _ etc... Can you give an example of how to fix this: - use frames that open and close. - Free up Dataset resources (RAM) immediately. - minimize size of exe file - use Pool connection to avoid braking RDB system Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted November 14, 2023 Share Posted November 14, 2023 1 hour ago, Muhammad Idris said: Can you give an example of how to fix this: - use frames that open and close. - Free up Dataset resources (RAM) immediately. - minimize size of exe file - use Pool connection to avoid braking RDB system Humm... I will try Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted November 14, 2023 Share Posted November 14, 2023 On 11/7/2023 at 5:03 AM, Muhammad Idris said: but why is it that when I divide the service into 3 hyperservers the application slowdown doesn't occur Muhammad, 1. Are you using your own technic for loadbalancing or official Server Farm hyperservers ? 2. In the second case, did you follow step by step the doc : https://www.unigui.com/doc/online_help/hyperserver-server-farm.htm Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 15, 2023 Author Share Posted November 15, 2023 9 hours ago, Abaksoft said: Muhammad, 1. Are you using your own technic for loadbalancing or official Server Farm hyperservers ? 2. In the second case, did you follow step by step the doc : https://www.unigui.com/doc/online_help/hyperserver-server-farm.htm i just split the service into 3 hyperservers running the same exe in different folders and different ports. so we allow clients to access 3 different ports: 8077, 8075, 8078 Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted November 15, 2023 Share Posted November 15, 2023 Definitivly, this is not a good way for absorbing much incoming sessions. Can you take time to read the doc and deploy correctly your project on a true and conventional farm servers. Consider this is a real chalenge this week Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 15, 2023 Author Share Posted November 15, 2023 6 hours ago, Abaksoft said: Definitivly, this is not a good way for absorbing much incoming sessions. Can you take time to read the doc and deploy correctly your project on a true and conventional farm servers. Consider this is a real chalenge this week Can the 3 service farms that I create with 3 ports become one port? so that the client only goes to port 8077 for example Quote Link to comment Share on other sites More sharing options...
Kos Posted November 15, 2023 Share Posted November 15, 2023 nginx .conf split_clients "${remote_addr}AAA" $app_addr { 30.0% "127.0.0.1:8075"; 30.0% "127.0.0.1:8077"; * "127.0.0.1:8078"; } server { #... location / { proxy_pass http://$app_addr; proxy_set_header X-Real-IP $remote_addr; proxy_set_header Host $host:$server_port; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Host $host; } } Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted November 16, 2023 Author Share Posted November 16, 2023 20 hours ago, Kos said: nginx .conf split_clients "${remote_addr}AAA" $app_addr { 30.0% "127.0.0.1:8075"; 30.0% "127.0.0.1:8077"; * "127.0.0.1:8078"; } server { #... location / { proxy_pass http://$app_addr; proxy_set_header X-Real-IP $remote_addr; proxy_set_header Host $host:$server_port; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Host $host; } } Previously I had used nginx, but it could only run app.exe, not hyperserver.exe Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted December 1, 2023 Author Share Posted December 1, 2023 On 11/14/2023 at 7:32 AM, 55143681 said: MY project in my office network, about seventy users, a *.exe runs fast. My application is accessed by more than 250 users. and before using UniGui, our SQL Server database had been running and accessed from 2012 with various performance tuning indexes, queries and partiton tables. If there is someone in this group whose application is accessed by more than 250 users and is stable and not slow, then please provide a solution. Quote Link to comment Share on other sites More sharing options...
Muhammad Idris Posted December 7, 2023 Author Share Posted December 7, 2023 On 11/15/2023 at 10:14 PM, Kos said: nginx .conf split_clients "${remote_addr}AAA" $app_addr { 30.0% "127.0.0.1:8075"; 30.0% "127.0.0.1:8077"; * "127.0.0.1:8078"; } server { #... location / { proxy_pass http://$app_addr; proxy_set_header X-Real-IP $remote_addr; proxy_set_header Host $host:$server_port; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Host $host; } } Sir, how do I set it to read and save PDF files in the specified folder? because when using Nginx the PDF file is not readable, whereas using the hyperserver itself it can be read. Thank You Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.