3 messages in com.mysql.lists.javaRE: mysql performance| From | Sent On | Attachments |
|---|---|---|
| Bin Cai | 06 Nov 2001 10:32 | |
| Ylan Segal | 06 Nov 2001 10:39 | |
| Taglang, Guillaume | 06 Nov 2001 11:04 |
| Subject: | RE: mysql performance |
|---|---|
| From: | Ylan Segal (yl...@digiworks.tv) |
| Date: | 11/06/2001 10:39:54 AM |
| List: | com.mysql.lists.java |
I would really advise you to use a Connection Pooling package. It will increase your performance and resources used dramatically.
There are many available out there, and I would not know which one to recommend since I use one developed in-house in my company.
As for the number of concurrent users, it is not really a problem, granted that the server that the system is runnning in can handle the load.
Good Luck.
Ylan Segal.
-----Original Message----- From: Bin Cai [mailto:ca...@ugrad.cs.ualberta.ca] Sent: Tuesday, November 06, 2001 12:33 PM To: ja...@lists.mysql.com Subject: mysql performance
Hello, I really need a confirmation for mysql performance. I am working on application about "online exam". that is about students taking exam by internet(IE or Netscape). considering 120 to 180 students take the exam at the same time. every exam has 20 multiple choice questions, almost every question has plots. students can get access to server by internet and login to exam by their id and names. they submit the answer and can also check their marks after they submit their exam.
the system can keep the record of every student including their answers to every question and their final marks. considering the system hold 2000 students .
My application is designed by using mysql as database with java and java servlet as programming enviroment and tomcat 3.2.3 as server.
I am worried about the performance of mysql in terms of multi user performance, speed, reliability , security and other things i don't know
Any one can give me some instruction and i will really appreciate. bin
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.