RE: Java+MySQL for Big Systems - jasmine harris - com.mysql.lists.java

4 messages in com.mysql.lists.javaRE: Java+MySQL for Big Systems

From	Sent On	Attachments
Edilmar Alves	02 Aug 2000 09:46
Frank E Mabrey	02 Aug 2000 19:51
Steve Barrett	03 Aug 2000 00:13
jasmine harris	04 Aug 2000 11:37

Subject:	RE: Java+MySQL for Big Systems
From:	jasmine harris (emin...@hotmail.com)
Date:	08/04/2000 11:37:15 AM
List:	com.mysql.lists.java

I'm currently using MySQL and Java Servlets for a large database and website (not quite 2,000 tables - like yours) and it seems to be holding up. We plan to move the production site to Oracle. I do wish that MySQL would support foreign key constraints, but I know that this is not the place to discuss that issue. I found this website by mistake and you MUST read it for it is very informative.

Jasmine

http://openacs.org/why-not-mysql.html

From: "Steve Barrett" <ste...@eurovis.demon.co.uk>

To: "Frank E Mabrey" <fra...@mabrey.com>, "Edilmar Alves" <edil...@intersite.com.br>, <ja...@lists.mysql.com> CC: <baca...@intersite.com.br> Subject: RE: Java+MySQL for Big Systems Date: Thu, 3 Aug 2000 08:14:03 +0100

The backend database and the whether you use java servlets or not has no bearing at all on the limited capabilities of your browsers or network bandwidth (as long as you didn't plan to use java applets which it doesn't sound like you need to).

Your java servlets and database will on run on your web/application server - so it's the capabilities of this that determine what you run on it. The only importance to you is to keep the HTML that your code generates to a limited size (no graphics would be a big contributing factor).

The choice of database is going to be purely down to data volumes and simultaneous requests. I have no idea of the capabilities of MySQL but I'm reasonably confident in it as so many people use it for websites. I know about Oracle and you certainly would have no problems with in terms of scability and handling your needs.

Regards,

-----Original Message----- From: Frank E Mabrey [mailto:fra...@mabrey.com] Sent: 03 August 2000 03:52 To: Edilmar Alves; ja...@lists.mysql.com Cc: baca...@intersite.com.br Subject: Re: Java+MySQL for Big Systems

If you need to communicate with dumb terminals at 9.6KB you will not be using a web server unless they are connected to a Unix box running something like "lynx". If all your data is HTML pages you probably don't want to use MySQL or any other database, just text HTML with hyperlinks.

Hope this helps.

-----Original Message----- From: Edilmar Alves <edil...@intersite.com.br> To: ja...@lists.mysql.com <ja...@lists.mysql.com> Cc: baca...@intersite.com.br <baca...@intersite.com.br> Date: Wednesday, August 02, 2000 7:12 PM Subject: Java+MySQL for Big Systems

Hi,

I have started a very big project, with more than 2.000 tables into ER-model.

This software must run at Web Browser, with a little (or none) images, only pure-HTML texts, cause of performance.

The workstations may be from PCs into a local network to remote terminals with 9.6kbps bandwidth.

I have used Java Servlets + MySQL to E-Commerce Systems, but now I have a big Intranet System to develop. I'm worried about using Java, cause your performance. Someone talks to me about using something like Oracle DB + PL/SQL (native Oracle language).

Does anyone have experience with Java+MySQL for Big Systems, or something like Oracle is better ?

Thanks in advance,

--------------------------------------------------------------------- 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.