Performance, 100´s of new accounts?

hpl123

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

hpl123

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

Forgot to say, the server is a dedicated server.

Powerm

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.

hpl123

Thanks powerm. Good to know. Regarding account creation and concurrent users, do you think the the server will hold?

Powerm

Yes Sir, good luck :lol:

hpl123

Thanks powerm (Sir) 🙂

lineamovil

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.

BenHayat

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.

Hi;

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.

lineamovil

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/57250/optimize-a-mysql-database-using-mysql-workbench

BenHayat

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/57250/optimize-a-mysql-database-using-mysql-workbench

That's a good info about Workbench. So you basically ran Optimize table against all your tables and now the performance is back?

customaware

Nice Tip Carlos.

Thanx

lineamovil

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!

hpl123

Good tip Carlos,
Thanks