Wilton Ergon Posted May 4, 2020 Share Posted May 4, 2020 I am renting a dedicated server only for unigui applications, I already have another server for the database. I would like to know if it makes a difference to have a server with 2 processors in the server, if the applications created in unigui will make use of the 2 processors. I use IIS with windows server 2016 Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted May 4, 2020 Administrators Share Posted May 4, 2020 Hi, uniGUI app will use all available CPUs, cores and threads. However, it only makes sense if your app actually needs that computing power. Otherwise non-used cores will remain idle most of the time. Quote Link to comment Share on other sites More sharing options...
Wilton Ergon Posted May 5, 2020 Author Share Posted May 5, 2020 my server has 95 sites instantiated on iis, i have peaks of thousands of simultaneous users (adding all sites) (5000+ users) each site has access to its own sql server database, with the covid pandemic, this is increasing substantially , so we are hiring a new server dedicated only to unigui. in a scenario like this compiling the project in 64 bits, is there any improvement in performance? We are using hyperserver on some of these sites (the ones with the most access) Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted May 5, 2020 Share Posted May 5, 2020 While waiting for ServerFarm, you can use pooling technic. This inhance drastically the connexion ressources and time. For Pooling, each DBAware has its setting, here is an example for IBDAC (Devart) / FireBird : function TUniMainModule.fct_Connexion_Pool(DB_Path:string; var error:boolean):TIBCConnection; begin //1. Result := TIBCConnection.Create(nil); Result.Username:='sysdba'; Result.Password:='masterkey'; Result.ConnectString:='Port=3050; User ID=sysdba; Password=masterkey; Use Unicode=True; Login Prompt=False'; Result.Port:='3050'; Result.AutoCommit := False; Result.ClientLibrary:=WindowsNewDirectory.GetProgramFilesDir + '\FireBird\FireBird_3_0\fbclient.dll'; //2. Pooling Technic //==================================================== Result.PoolingOptions.MinPoolSize:=0; Result.PoolingOptions.MaxPoolSize:=100; Result.PoolingOptions.ConnectionLifetime:=10000; //ms Result.PoolingOptions.Validate:=True; Result.Pooling:=True; //==================================================== //3. Result.Options.EnableMemos :=False; Result.Options.EnableFMTBCD :=True; Result.Options.UseUnicode :=True; Result.Options.Charset :='UTF8'; Result.Options.KeepDesignConnected :=False; //4. try error:=False; Result.Database:=DB_Path; Result.Connect; except on E: Exception do begin Result.Free; error:=True; showMessage('Problem DB : ' + E.Message); end; end; end; Quote Link to comment Share on other sites More sharing options...
eduardosuruagy Posted May 5, 2020 Share Posted May 5, 2020 1 hour ago, Abaksoft said: Enquanto aguarda o ServerFarm , você pode usar a técnica de pool . Isso inverte drasticamente os recursos e o tempo de conexão. Para Pooling, cada DBAware tem sua configuração. Aqui está um exemplo para IBDAC (Devart) / FireBird : Can you do that with firedac? Quote Link to comment Share on other sites More sharing options...
picyka Posted May 5, 2020 Share Posted May 5, 2020 5 minutes ago, eduardosuruagy said: Can you do that with firedac? http://docwiki.embarcadero.com/RADStudio/Rio/en/Multithreading_(FireDAC) Quote Link to comment Share on other sites More sharing options...
Ronbral Posted May 5, 2020 Share Posted May 5, 2020 10 horas atrás, wilton_rad disse: meu servidor possui 95 sites instalados no iis, tenho milhares de usuários simultâneos (adicionando todos os sites) (mais de 5000 usuários) cada site tem acesso ao seu próprio banco de dados sql server, com uma pandemia oculta, isso é substancialmente , então está contratando um novo servidor dedicado apenas ao único. em um cenário como esse, compilando o projeto em 64 bits, há alguma melhoria no desempenho? Estamos usando o hiperserver em alguns desses sites (aqueles com mais acesso) Wilton, Muitas personalizações podem ser feitas no nível do sistema operacional para obter melhor desempenho. Considere também a versão do Windows Server Datacenter, If you have a lot of procs Cores. What is the hardware; Processor, Mem and SSD? Quote Link to comment Share on other sites More sharing options...
Wilton Ergon Posted May 7, 2020 Author Share Posted May 7, 2020 4 SSD 960gb in RAD 10 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.