We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.
Are there any particular pitfalls of using mySQL instead of Oracle?
I'm a novice when it comes to evaluting different SQL solutions.
We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.
Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.
If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...
4  2053 
Jan Olsen wrote: We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.
Are there any particular pitfalls of using mySQL instead of Oracle?
Certainly there are some tasks that Oracle products can do, which MySQL
cannot. However, a great majority of projects fall into a category that
both MySQL and Oracle can support successfully. And the price
difference is so great (even assuming you pay for a commercial license
for MySQL) that you should really consider carefully if MySQL can do the
job for you.
We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.
Try reading through the case studies on the MySQL.com web site: http://www.mysql.com/it-resources/case-studies/
There are quite a few real-world installations that use MySQL for data
volume similar to what you're describing, and where stability is crucial.
No database system can work magic, however. Both Oracle and MySQL--and
any other RDBMS--require good design, good administration practices, and
regular maintenance to keep things running well.
Regards,
Bill K.
Jan Olsen wrote: We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.
Are there any particular pitfalls of using mySQL instead of Oracle?
I'm a novice when it comes to evaluting different SQL solutions.
We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.
Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.
If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...
Jan,
The key issue you have to resolve is your organization's
priorities. It sounds as though data integrity is the number
one priority. If, when using product X, your database crashes
and you can recover within a satisfactory time (from a business
point of view) that product meets your requirements.
I can't speak for MySQL since I don't know it well enough to
comment.
When it comes to Oracle the ability to take hot back ups used in
conjunction with transaction logging allows very fast recovery.
If needed, and the budget permits, it is possible to set up a
24 by 7 Oracle setup that will probably by 100% available and
will definitely meet 99.999% availability. With Oracle it isn't
cheap, but it is doable.
HTH
Jerry
In all of this, how does MS SQL compare with mySQL or Oracle? I suppose
perhaps no better than mySQL?
jerry gitomer wrote: Jan Olsen wrote: We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.
Are there any particular pitfalls of using mySQL instead of Oracle?
I'm a novice when it comes to evaluting different SQL solutions.
We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed, the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.
Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.
If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...
Jan,
The key issue you have to resolve is your organization's
priorities. It sounds as though data integrity is the number
one priority. If, when using product X, your database crashes
and you can recover within a satisfactory time (from a business
point of view) that product meets your requirements.
I can't speak for MySQL since I don't know it well enough to
comment.
When it comes to Oracle the ability to take hot back ups used in
conjunction with transaction logging allows very fast recovery.
If needed, and the budget permits, it is possible to set up a
24 by 7 Oracle setup that will probably by 100% available and
will definitely meet 99.999% availability. With Oracle it isn't
cheap, but it is doable.
HTH
Jerry
Jan wrote: In all of this, how does MS SQL compare with mySQL or Oracle? I suppose
perhaps no better than mySQL?
jerry gitomer wrote:
Jan Olsen wrote:
We're planning an SQL-based solution, possibly mySQL for Windows or
Linux. But some in the organization might favor Oracle.
Are there any particular pitfalls of using mySQL instead of Oracle?
I'm a novice when it comes to evaluting different SQL solutions.
We expect to have maximum 10 million records for our largest table,
and perhaps 50 different small tables of up to 1 million records each.
Uncompressed , the system will use no more than 20 GB. Maximum 100
persons will have access to the system, perhaps using ODBC or a web
interface. Most processes are batch based, but there may be some
manual look-ups, and even fewer manual updates.
Data integrity is important, we have once had an MS Access system with
just 1GB data, and frequently discovered that data became corrupted
when data was accessed/written via the LAN.
If mySQL have similar problems or perform very sluggishly or crashes
freqenutly when compared to Oracle, I guess I can't argue for mySQL...
Jan,
The key issue you have to resolve is your organization's
priorities. It sounds as though data integrity is the number
one priority. If, when using product X, your database crashes
and you can recover within a satisfactory time (from a business
point of view) that product meets your requirements.
I can't speak for MySQL since I don't know it well enough to
comment.
When it comes to Oracle the ability to take hot back ups used in
conjunction with transaction logging allows very fast recovery.
If needed, and the budget permits, it is possible to set up a
24 by 7 Oracle setup that will probably by 100% available and
will definitely meet 99.999% availability. With Oracle it isn't
cheap, but it is doable.
HTH
Jerry
Jan,
If you are talking about a "You bet your company" database you
are probably best off using Oracle or DB2 and getting one of the
more expensive service agreements. The reason is that sooner or
later you will have problems that require substantial vendor
support. I have experience with all three companies and, IMHO,
Oracle and IBM both have better support than Microsoft.
HTH
Jerry This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Mitch |
last post by:
Here is the basic scenario:
- Configuration data is gathered from Oracle servers then ftp'd to my
apache / mysql server.
- The apache / mysql server receives the datafile from the Oracle
clients and loads the data into a MySQL database.
- The webpages are coded using PHP, SQL, and some JavaScript.
|
by: Mark Wilson CPU |
last post by:
A colleague has written a prototype program in PHP, using a MySQL
database.
It's a relatively simple app, with a restricted set of mysql commands
used (see below). The MySQL DB is being replaced with an Oracle DB
(same schema). My plan
1) globally replace the few mysql commands with intermediate
equivalents (such as myDB_connect for mysql_connect)
2) those central functions would then (for now) call the original
mysql function to prove...
|
by: jonathan |
last post by:
hey all,
I realize that this question might pop up from time to time, but I
haven't seen it a while and things might of changed, so -
Right now (July 2004) how does mysql stand up in comparison to oracle?
We are seriously considering migrating our multi-processor oracle
system to mysql to save on licensing costs, and would need several
features that mysql may or may not have:
|
by: Cern |
last post by:
Is it somebody out there who has made a migration from an Oracle server to an MySQL server??
The scenario is as simply:
I've got a Oracle 8 server with a database with content that I want to transfer to
a MySQL database. No special data, constraints etc that MySQL not will handle.
My solution is to reverse engineer the database from ERStudio and then produce a SQL script that
will insert the data into the MySQL engine.
But I can't do...
|
by: Sai Hertz And Control Systems |
last post by:
Dear all,
Their was a huge rore about MySQL recently for something in java functions
now theirs one more
http://www.mysql.com/doc/en/News-5.0.x.html
Does this concern anyone.
What I think is PostgreSQL would have less USP's (Uniqe Selling Points
| | |
by: Mairhtin O'Feannag |
last post by:
Hello,
I have a client (customer) who asked the question : "Why would I buy and
use UDB, when MySql is free?"
I had to say I was stunned. I have no experience with MySql, so I was
left sort of stammering and sputtering, and managed to pull out something
I heard a couple of years back - that there was no real transaction
safety in MySql. In flight transactions could be lost.
|
by: timothy.williams |
last post by:
Hi.
I have a Python program that parses a file and inserts records into a
database with MySQLdb. I recently upgraded to MySQL 5.0.8, and now my
parser runs *really* slow. Writing out to CSV files is fine, but when I
try to insert the same records in a MySQL5 database, it slows to a
crawl. Using MySQL 4.1 seems fine. The data seems to be inserted
correctly, it's just really slow.
Has anyone else noticed a similar problem using MySQL5...
|
by: The|Godfather |
last post by:
Hello,
I have a "slight" problem with the mySQL C API. I want to bind vectors
for output/input prepared statements. However, the C API does NOT
support such data binding. Is there ANY other way to do a
bulk-INSERT/DELETE/UPDATE or bulk-SELECT in mySQL C API? I mean, one
can do it with a loop, but obiously the goal is to have a higher
performance.I tried it with a plain-old loop, but it is still slow.
Oracle supports such feature and it...
|
by: Einstein30000 |
last post by:
Hi,
in one of my php-scripts is the following query (with an already open
db-connection):
$q = "INSERT INTO main (name, img, descr, from, size, format, cat,
host, link, date) VALUES ('$name', '$img', '$descr', '$user', '$size',
'$format', '$cat', '$host', '$link', '$date')" or die(mysql_error());
And when the query gets executed i get back the following error:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
