Anto90

We have a website developed with intraweb technology in delphi. (In the period of maximum work we get to have about 2000 active sessions at the same time) (Database weight 15gb) As support we use interbase 2020 update 3 (on a separate server from the one where the webserver runs) and firedac connection technology with delphi 11.2. (The webserver is IIS) What we notice is that as the number of connected users increases, the ibserver network traffic increases a lot up to 5gb/s, congesting the entire network and significantly reducing system performance. (Making navigation between pages very slow) Database connections are made stateless, each request does its job and the db connection is closed when finished. Downgrading to delphi 11.0 the problem seems to decrease traffic, however slow down system performance. However the traffic is not justified by the amount of data exchanged. Fdconnection of firedac is set as protocol tcp and ip the destination server of the database. The two servers are connected in a 10 gigabit LAN. Each session as defined in the intraweb has its own dedicated thread where the datamodule is created with the components for connecting to the database and executing queries) As suggested by embarcadero we increased database pages to 8192 and buffers 200000. How to handle requests to the db in a stateless way (connection and disconnection can significantly degrade system performance?) In my datamodule there are fdconnection with tcp/ip protocol and port 3050 and then with fdquery fd command to execute the queries. What optimal settings for fdconnection can be used.? Does anyone have any experience with this yet? Thank you Andrea Antonini

HI thank you for your response fiMeta in included in cache items. We do not use autocommit. we manage transaction. At end of each request me call commit. FetchOptions.Autofetchall is afAll. Thank you.