Applications using Hyper Server become slow when there are more than 200 sessions

[Muhammad Idris]

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

[Muhammad Idris]

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

[IRWANTO82]

your .exe binary and hyperserver using win32 or win64 ?

 

 

[Muhammad Idris]

23 hours ago, IRWANTO82 said:

your .exe binary and hyperserver using win32 or win64 ?

 

 

Win32

[Muhammad Idris]

On 11/8/2023 at 10:33 PM, IRWANTO82 said:

your .exe binary and hyperserver using win32 or win64 ?

 

 

.exe binary

 

hyperserver 64

[Muhammad Idris]

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?

[Abaksoft]

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.

[Muhammad Idris]

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?

[Abaksoft]

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...

 

[55143681]

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.

[Abaksoft]

2 hours ago, 55143681 said:

 

If you are using mysql

He is using  SQL Server 2019 Enterprise.

[picyka]

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.

[55143681]

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.

[Muhammad Idris]

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

[Muhammad Idris]

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

[Muhammad Idris]

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
 

[Abaksoft]

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

[Abaksoft]

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

 

[Muhammad Idris]

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

[Abaksoft]

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

[Muhammad Idris]

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

[Kos]

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;
 }
 
}

 

[Muhammad Idris]

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

[Muhammad Idris]

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.

[Muhammad Idris]

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