Hi all,
I am planning my application etc. and have a question about performance. If I use a 3.2Ghz CPU, 8GB ram, Java 64bit and my application is medium to fairly complex. Would my server be able to handle a couple of hundred (high count) of new users (creating accounts, testing the application etc.) if i e.g. provide a free trial? (this will level out but the activity etc. could be a lot when launching the application)
Please share your experience and also please share the maximum number of concurrent users you have had in your applications.
Thanks in advance, regards Henrik
Performance, 100´s of new accounts?
Performance, 100´s of new accounts?
Henrik (V8 Developer Ed. - Windows)
Re: Performance, 100´s of new accounts?
Forgot to say, the server is a dedicated server.hpl123 wrote:Hi all,
I am planning my application etc. and have a question about performance. If I use a 3.2Ghz CPU, 8GB ram, Java 64bit and my application is medium to fairly complex. Would my server be able to handle a couple of hundred (high count) of new users (creating accounts, testing the application etc.) if i e.g. provide a free trial? (this will level out but the activity etc. could be a lot when launching the application)
Please share your experience and also please share the maximum number of concurrent users you have had in your applications.
Thanks in advance, regards Henrik
Henrik (V8 Developer Ed. - Windows)
By experience I can say that beside the concurrent users and new account creation the most important CPU/ Memory load is due to the processes and rules attached to the BO. Your hardware specifications are perfect.
Independent Developer
www.atwing.com
www.atwing.com
-
- Posts: 201
- Joined: Tue Jul 27, 2010 2:17 am
- Location: Mexico
Hello!
I have an Corei3 Procesor
4 GB RAM
1 TB HD
MySQL 5.6 (in the task manager shows 590,000 K)
AwareIm Version 5.8
AwareIM Config:
AwareIM Server: 1024
Tomcat: 512
Config Tool: 256
We have like 15 - 20 users at the most.
Have several BO, the one that I use the most is 100,000 records
Others are: 250,000 records.
It use to be fast, but now it is slow. I have some rules that I need to use, but even queries are slow now.
Thank you for your help.
I have an Corei3 Procesor
4 GB RAM
1 TB HD
MySQL 5.6 (in the task manager shows 590,000 K)
AwareIm Version 5.8
AwareIM Config:
AwareIM Server: 1024
Tomcat: 512
Config Tool: 256
We have like 15 - 20 users at the most.
Have several BO, the one that I use the most is 100,000 records
Others are: 250,000 records.
It use to be fast, but now it is slow. I have some rules that I need to use, but even queries are slow now.
Thank you for your help.
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
Hi;lineamovil wrote: It use to be fast, but now it is slow. I have some rules that I need to use, but even queries are slow now.
Could you be more specific, in what cases it is slow? i.e. Adding/deleting records or fetching single record or running a process or is it ONLY queries?
Slowness in different part of an app, could be from different causes. This way, the Aware experts on the forum can have better info to make suggestions.
Hope this helps.
-
- Posts: 201
- Joined: Tue Jul 27, 2010 2:17 am
- Location: Mexico
Hello!
Ok it is working fine again!
I did a database maintanance in MySQL and that was it. It is super fast once again.
Sorry!
http://dba.stackexchange.com/questions/ ... -workbench
Ok it is working fine again!
I did a database maintanance in MySQL and that was it. It is super fast once again.
Sorry!
http://dba.stackexchange.com/questions/ ... -workbench
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
That's a good info about Workbench. So you basically ran Optimize table against all your tables and now the performance is back?lineamovil wrote:Hello!
Ok it is working fine again!
I did a database maintanance in MySQL and that was it. It is super fast once again.
Sorry!
http://dba.stackexchange.com/questions/ ... -workbench
-
- Posts: 2405
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
-
- Posts: 201
- Joined: Tue Jul 27, 2010 2:17 am
- Location: Mexico
Hello!
Yes that was it. It made it very fast. I have to say that I use php to extract some data in txt from that table. So that could also have created the problem. (It has over 1 year working)
It took almost 1 minute to show the query. Now in less than 15 sec shows over 100,000 records.
Thanks!
Yes that was it. It made it very fast. I have to say that I use php to extract some data in txt from that table. So that could also have created the problem. (It has over 1 year working)
It took almost 1 minute to show the query. Now in less than 15 sec shows over 100,000 records.
Thanks!
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO