Anto90

this is an example. i Call directly method on execute for testing... FFCMSender is object in thread... Thank you Andrea procedure TTimerThreadSpedisciMailingList.Execute(); begin SendPushNotificationNewVersion(FFCMSender,'testtoken','test','test'); end;

Good morning, i now switch to send push notifications with firebase using the new method legacy with token with the example in kastri. I port the example in a thread and then implment the method. Can i use the example in a multi thread enviroment or some operation must be execute in main thread? I reported a small implementation of thread but sometime i get showmessage "Nothing to do ". Can someone help me? I attached an small example of my thread. Thank you Andrea Esempio.pas

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.

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