erich.wanker Posted February 13, 2021 Share Posted February 13, 2021 hello .. short question - and i know it is not possible to answer .. but i hope someone can give a ESTIMATE :-) HOW MANY USERS CAN WORK (create, edit, update and delete of Records) simultan on such a hardware Hardware: Typ: Dedicated Server L CPU: 4 Core x 3,5 GHz (Intel Xeon E3-1230 v6) RAM: 16 GB HDD: 2 x 1000 GB Software RAID 1 Software: Windows Sever 2019 Apache Webserver UniGui exe (via Hyperserver.dll) with size of 30MB Connection to a MySQL Database (local) with 30 Tables á 20 fields / with ZeosLib in MainModule the application uses a lot of uniDGBrids / forms with uniDBEdit / ... has 20 Forms and 20 Frames ... Link to comment Share on other sites More sharing options...
Abaksoft Posted February 14, 2021 Share Posted February 14, 2021 Hello Eric, I will not answer to your question. But just push a reserve about ZeosLib. in unigui forum, you will see that the uses of this library is depreciated. use instead a rock one from Devart. Regards 1 Link to comment Share on other sites More sharing options...
Wilton Ergon Posted February 16, 2021 Share Posted February 16, 2021 On 13/02/2021 at 11:27, erich.wanker said: olá .. pergunta curta - e eu sei que não é possível responder .. mas espero que alguém possa dar uma estimativa 🙂 QUANTOS USUÁRIOS PODEM TRABALHAR (criar, editar, atualizar e excluir registros) simultaneamente em tal hardware Hardware: Tipo: Servidor Dedicado L CPU: 4 núcleos x 3,5 GHz (Intel Xeon E3-1230 v6) RAM: 16 GB HDD: 2 x 1000 GB Software RAID 1 Programas: Windows Sever 2019 Servidor Apache Exe UniGui (via Hyperserver.dll) com tamanho de 30 MB Conexão a um banco de dados MySQL (local) com 30 tabelas á 20 campos / com ZeosLib no MainModule o aplicativo usa muitos uniDGBrids / forms com uniDBEdit / ... tem 20 formulários e 20 frames ... there are a multitude of factors that can influence this calculation. some suggestions: if you open your forms in tabs, avoid leaving too many tabs open, I limit it to a maximum of 4, when the user opens to 5, I remove it to 1, avoid opening your queries with select * from table open your forms without data, and offer a search feature, and limit the return on that search. avoid using sequeced timer enabled. avoid using forms, use frames instead. avoid leaving the system open indefinitely, set a time limit to end the application without use. my application has about 350 forms and consumes an average of 15 mb per user. having more memory, and more processor, does not mean that you can add new users in the same proportion, you can reach the limit of the operating system, even if you do not use all available memory and processor. if you have a large capacity server, it is better to create virtual machines on that server, than to use only a large server. 2 Link to comment Share on other sites More sharing options...
Ronbral Posted February 19, 2021 Share Posted February 19, 2021 Hi Wilton; what negative impact of using the timer did you detect? Link to comment Share on other sites More sharing options...
Abaksoft Posted February 19, 2021 Share Posted February 19, 2021 6 hours ago, Ronbral said: Hi Wilton; what negative impact of using the timer did you detect? Obviously, if you let a timer working unnecessarily, it will consume additional resources. Get into the habit of : - stopping any timer onclose form or on destroy frame. - Same : Closing any DataSet onclose form or on destroy frame. Link to comment Share on other sites More sharing options...
Abaksoft Posted February 20, 2021 Share Posted February 20, 2021 Erratum : Infact, unigui will free Dataset ressources automatically. http://www.unigui.com/doc/online_help/index.html?web-application-scalability.htm "When you place a dataset on a form, it will be created when the form is shown and destroyed when the form is closed. This approach will optimize memory usage related to datasets". Link to comment Share on other sites More sharing options...
Wilton Ergon Posted February 22, 2021 Share Posted February 22, 2021 On 18/02/2021 at 23:20, Ronbral said: Olá, Wilton; que impacto negativo do uso do cronômetro você detectou? http://unigui.com/resources/online-documentation/component-reference-manual find sequenced Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now