Hi all!
I'm developing a system using both MySQL and Oracle for document processing. I issue a
series of queries to the database, depending on the document size. For big documents,
both databases behave in the same way but, when using small documents, MySQL finishes
quickly while Oracle
the appropriate patches on Oracle can make a big
difference too.
--Walt
-Original Message-
From: Jaime [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 4:59 AM
To: [EMAIL PROTECTED]
Subject: MySQL vs Oracle
Hi all!
I'm developing a system using both MySQL and Oracle
: Weaver, Walt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 4:00 PM
Subject: RE: MySQL vs Oracle
You didn't provide much information about your system.
What version of MySQL? Oracle?
With Oracle, which optimizer are you using? Oracle, compared to MySQl,
is very tunable
: Wednesday, June 16, 2004 8:12 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL vs Oracle
I'm using Oracle 8.0.5 and MySQL 4.1.1a
I'm not optimizing Oracle nor MySQL, because I don't want future users
messing with optimizations.
I access through JDBC drivers. Oracle usually needs 10
seconds
10 seconds !?Unless that query is huge and without indexes, it should
run MUCH quicker.
I'm using Oracle 8.0.5 and MySQL 4.1.1a
I'm not optimizing Oracle nor MySQL, because I don't want future users
messing with optimizations.
I access through JDBC drivers. Oracle usually needs 10
Mike,
A lot of my Oracle / MySQL questions got answered by searching the
archives at http://
lists.mysql.com/php/search.php for Oracle (so many!) or Oracle ...
e.g Oracle Backup etc.
Thanks,
Sam Bauer, Oracle DBA
-
Before
We are looking to move to a mySQL db for an application that will possibly
process 100's of millions of rows a day and are looking to do it cheaper
than an oracle solution. I am new to the mySQL arena and am interested in
the groups experience in what mySQL does not do (especially related to
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql,
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql,
: Mysql vs. Oracle and concat ||
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my
vs. Oracle and concat ||
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've
:I want to make a sql query in mysql, with a concat (||) known i Oracle
:world.
:
:Like this.
:
:select numer ||','|| text from Table:
Instead, try the following:
SELECT CONCAT(number, ',', text) FROM Table;
-
Hi Frank,
You can use the concat() function:
select concat(numer, ',', text) from Table.
The online docs for MySQL contain a great reference for functions:
http://www.mysql.com/doc/en/Functions.html
--jeff
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql,
To: [EMAIL PROTECTED]
Subject: Mysql vs. Oracle and concat ||
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope
From: MySQL [EMAIL PROTECTED]
select numer ||','|| text from Table:
SELECT CONCAT(numer, '||', text) FROM Table;
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
-
Before posting, please check:
You almost answered your own question. In mysql you use the concat()
command:
select concat(number,',',text) from Table
On Thursday, September 26, 2002, at 03:17 PM, MySQL wrote:
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
Hi Frank-
I'm new to the MySQL world, and I am also a DBA with an Oracle background.
This was a surprise to me as well. However, the only solution that I know
of is to encapsulate your SELECT elements in a Concat() function. So, your
SQL statement would be:
select concat(numer, text)
from
At 20:46 26/09/2002 +0200, MySQL wrote:
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
You need to specify the keyword CONCAT and enclose it in brackets,
like this:
Robert Fox wrote:
Hi Frank-
I'm new to the MySQL world, and I am also a DBA with an Oracle background.
This was a surprise to me as well. However, the only solution that I know
of is to encapsulate your SELECT elements in a Concat() function. So, your
SQL statement would be:
select
]
Subject: MySQL vs. Oracle (not speed)
A company I work with is in the process of upgrading its databases from
some
motheaten system to something current. My impression is that they
want to go with Oracle, and I'm not sure if this is based on anything
other than being impressed with the size
To: [EMAIL PROTECTED]
Subject: MySQL vs. Oracle (not speed)
A company I work with is in the process of upgrading its databases from
some
motheaten system to something current. My impression is that they
want to go with Oracle, and I'm not sure if this is based on anything
other than being impressed
have store procedures , dosent have a complete SQL command set...
I am using it becasue I am being forced to...
-Original Message-
From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 9:25 PM
To: [EMAIL PROTECTED]
Subject: MySQL vs. Oracle (not speed
Hi!
- Original Message -
From: John Griffin [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, August 16, 2002 3:29 PM
Subject: RE: MySQL vs. Oracle (not speed)
Hi Elizabeth,
The first question I would ask why don't you want Oracle? If you can't
come up with a good
Let's see if I can convince your managers:
1. Support
Oracle offers support, this is true, but if you want pay for support, you can
buy it from MySQL AB. They have MySQL for free and they also have a licence
you can buy and ask for support. If you want to keep free, this list is a
good point
PROTECTED]]
Sent: Thursday, August 15, 2002 9:25 PM
To: [EMAIL PROTECTED]
Subject: MySQL vs. Oracle (not speed)
A company I work with is in the process of upgrading
its databases from
some
motheaten system to something current. My impression
is that they
want to go with Oracle, and I'm
; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi,
I am beging using MySQL for quite a while and it is a
very good choice if you don't really need stored
procedures. MySQL provides a pretty good
implementation of a subset of MySQL-92, performance is
great, it is cross-platform
Mary Stickney wrote:
I have been doing speed tests the same query ran on MYSQL took 45
minutes
on MS-SQL it took 11 minutes..
yes you do get what you pay for
Why not post the queries and the schemas here? My guess is you don't
have something indexed correctly, or are using a
you do get what you pay for
-Original Message-
From: Francisco [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 8:47 AM
To: Mary Stickney; Elizabeth Bogner;
[EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi,
I am beging using MySQL for quite a while
what query was it may I ask ?
Tom
- Original Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Francisco [EMAIL PROTECTED]; Elizabeth Bogner
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 11:52 PM
Subject: RE: MySQL vs. Oracle (not speed)
I have been doing speed
To: Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
I have been doing speed tests the same query ran on MYSQL took 45
minutes
on MS-SQL it took 11 minutes..
yes you do get what you pay for
-Original Message-
From: Francisco [mailto
What exactly is Trolling
I find MYSQL to be slow , sorry if that doesn't met with your approval.
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:15 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi,
I am beging using MySQL for quite a while and it is a
very good choice if you don't really need stored
procedures. MySQL provides a pretty good
implementation of a subset of MySQL-92
, August 16, 2002 9:21 AM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi Mary,
I am not specially against or pro MySQL, Microsoft SQL
Server, Oracle or any other database. Teams make their
choices based on the project needs such as budget (is
your
The Open Source argument went down well with my management. Of course,
both Oracle and MySQL have full support teams, and should fix any bugs in
their databases promptly - and, so far as I know, they do. However, we have
had problems with (other) large companies in the past when we find bugs in
]]
Sent: Friday, August 16, 2002 9:25 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Not to open a can of worms here, Mary, but I'd love to know exactly how you
got those results, since they basically contradict every known benchmark I
To: [EMAIL PROTECTED]; Francisco; Elizabeth Bogner;
[EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
no need to get defensive ...
We did do a timed test.
I am trying to sped up a program that currently take over 12
hours to run...
I started running it yesterday morning and it is still
I did crash the MYSQL server the other day...
I am currently looping thru and getting the sales agent by agent.
I tried to do the query for all 804 agents at one time and after an hour and
a 1/2 and still not being done
decided against doing it that way.
next I decided I should have a table
Mary Stickney wrote:
What exactly is Trolling
I find MYSQL to be slow , sorry if that doesn't met with your approval.
But you don't give examples.
I've found MS-SQL to be slow at times, especially when used from JDBC,
but I don't make crack comments about it newsgroups without
),
KEY LobIdIndex (LOBID)
);
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:15 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Mary Stickney wrote:
I have been doing speed tests the same query ran
I did send in my query the day I joined this list and the table
structures.
I just did again...
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:47 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
'
ORDER BY AdminHierarchy.WritingAgentSlot,AdminCoverage.CoverageId,
AdminCoverage.CoverageIdSbc,
AdminHierarchy.ProducerID
-Original Message-
From: Tom Gao [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:22 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
what
PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Well, I meant this to be off-list (thus the next message) because I don't
want to start a round of M$ bashing, blah, blah...
But since I blew it already, I don't mean to sound harsh or defensive,
because, frankly, I don't have a vested interest
-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:28 AM
To: Mark Matthews; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
What exactly is Trolling
I find MYSQL to be slow , sorry if that doesn't met with your approval.
-Original
Subject: RE: MySQL vs. Oracle (not speed)
I am not for one or the other I just hate to wait
I need speed...
we already have a MS-SQL server , so no more money needs to me spent...
I did a 4 table join , drwing 3 years of sales data
table one 6.5 million records --- AdminHierarchy
;ProductIdIndex;15;AdminCoverage.ProductId;1
1;
;tempsap;ALL;10019;
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:21 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
Subject: RE: MySQL vs. Oracle (not speed)
explian returns this
;table;type;possible_keys;key;key_len;ref;rows;Extra
;table;type;possible_keys;key;key_len;ref;rows;Extra
;AdminCoverage;range;CoverageID,CoverageIdSbc,InitPremDateIndex,CovIdCovIdSb
cIndex,CovIdCovIdSbcInitPremIndex
Mary Stickney wrote:
no need to get defensive ...
We did do a timed test.
I am trying to sped up a program that currently take over 12 hours to run...
I started running it yesterday morning and it is still going. and going and
going...
Would it be possible for you to send the list the
yes I do
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:37 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Do you have an index on AdminProducer.taxid
Could you please send also tempsap ?
Thanks and regards,
Jocelyn
- Original Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Mark Matthews [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 4:55 PM
Subject: RE: MySQL vs. Oracle (not speed)
this is a read only
I think this is a touch on the negative side. I'm sure many people get soured on
MySQL when they to a post here and get yelled at for not trying hard enough. It
sounds like Mary is having a valid problem. Her query works fast in one database and
slow in the other. Because she did not come
Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Could you please send also tempsap ?
Thanks and regards,
Jocelyn
- Original Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Mark Matthews [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16
Hi,
Does the MySQL-4.1 development tree publicly available (if so, on which port
??)
Regards,
Jocelyn
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 3:42 PM
Subject: Re: MySQL vs. Oracle (not speed)
Hi!
I tested
I did the first day I joined the list and again today
-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:09 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi Mary,
It's not a question of approval. If you are having
to run... at this rate.
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:01 AM
To: Mark Matthews
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
I think this is a touch on the negative side. I'm sure
:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:17 AM
To: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
I am getting the taxid's I need from here so as not to try ane merge the
entire table..
and there are 833...
CREATE TABLE tempsap
PROTECTED]; Jocelyn Fournier
[EMAIL PROTECTED]; Mark Matthews [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, August 16, 2002 6:29 PM
Subject: RE: MySQL vs. Oracle (not speed)
incidentaly... Primary keys cant not be made on most of these tables due
to
the fact that
the farther back in time you got
[EMAIL PROTECTED]; Jocelyn Fournier
[EMAIL PROTECTED]; Mark Matthews [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, August 16, 2002 6:29 PM
Subject: RE: MySQL vs. Oracle (not speed)
incidentaly... Primary keys cant not be made on most of these tables due
to
the fact that
the farther back
PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 6:38 PM
Subject: RE: MySQL vs. Oracle (not speed)
looks to me like I can only make indexes on fields that are not null...
this one is not , not null
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent
Hi!
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 7:16 PM
Subject: Re: MySQL vs. Oracle (not speed)
Hi,
Does the MySQL-4.1 development tree publicly available (if so, on which
port
To: Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
I have been doing speed tests the same query ran on MYSQL took 45
minutes
on MS-SQL it took 11 minutes..
yes you do get what you pay for
-Original Message-
From: Francisco [mailto:[EMAIL
:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:32 AM
To: Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
I am not for one or the other I just hate to wait
I need speed...
we already have a MS-SQL server , so no more money needs to me spent...
I
sure that will take 5 years to run... at this rate.
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:01 AM
To: Mark Matthews
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
I think
Hello.
On Fri 2002-08-16 at 10:49:00 -0500, [EMAIL PROTECTED] wrote:
yes I do
But they are not listed in the Possible Keys column, which they
should. MySQL cannot use them for some reason.
I had a look at the posting with the CREATE TABLEs and it seems the
reason is that the columns are
use the same field type.
- Original Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Jocelyn Fournier [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 7:51 PM
Subject: RE: MySQL vs. Oracle (not speed)
I hope this makes it faster , the program just got done , it ran from 7:00
am
is not , not null
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:34 AM
To: Mary Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Hi,
I see you do an order by on AdminHierarchy.WritingAgentSlot
In the last episode (Aug 16), Mary Stickney said:
looks to me like I can only make indexes on fields that are not
null... this one is not , not null
Indexing of NULL columns went into Mysql 3.23.2 (Dec 16, 2000).
With tables this large, you might also want to raise some of the cache
...
this one is not , not null
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:34 AM
To: Mary Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Hi,
I see you do an order
: MySQL vs. Oracle (not speed)
In the last episode (Aug 16), Mary Stickney said:
looks to me like I can only make indexes on fields that are not
null... this one is not , not null
Indexing of NULL columns went into Mysql 3.23.2 (Dec 16, 2000).
With tables this large, you might also want to raise
Hi Mary,
My opinion:
MySQL forums are open to every one to said about him MySQL
problems,experience... etc.From performance point of view(slow query), 90 %
from the people which was posted on this forums , has problem with Database
and Table design.Comparing RDBMS it's not quite fairly because
strives for ANSI
compatibility like the other guys (PostgreSQL and Interbase).
-Original Message-
From: Kenneth Hylton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:47 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Our experience has been totally
using alter table...
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:08 PM
To: Mary Stickney
Cc: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
In the last episode (Aug 16), Mary Stickney said:
looks
.
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:48 PM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Hi Mary,
My opinion:
MySQL forums are open to every one to said about him MySQL
problems
Message -
From: Mary Stickney [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]; Elizabeth Bogner
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 16, 2002 9:58 PM
Subject: RE: MySQL vs. Oracle (not speed)
I don't have a choice as to what database I use I WISH I did
for reports only
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 2:14 PM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
...in this case...is very sad.
You use this query to generate
I'm sorry, but are you and I reading the same thread here? :)
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 12:01 PM
To: Mark Matthews
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
I think
You can index fields with nulls. You can't make into a primary key, that's
all.
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 12:38 PM
To: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed
ok fixed thoes every little bit helps... I hope.
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:00 PM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
I also noticed the field where you make
, August 16, 2002 10:21 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Hi,
Which columns are indexed in your table ?
What does EXPLAIN into MySQL return ?
Regards,
Jocelyn
- Original Message -
From: Mary Stickney [EMAIL
Adam,
[ mysql, query ]
However, you can do it manually (I think) by playing around with both
the order of the where clause and the order of the join clause
Yes.
Also, MySQL has a really wimpy default configuration (I can't figure out
why). Here is my /etc/my.cnf (I don't know what the
important at all. It's that I'm pretty confident that MySQL is
more than
fast enough for what we need, and when I see MySQL vs. Oracle questions
here they always tend to be about benchmarking, about convincing
people that MySQL is fast enough. I don't think that's the case, and I
know
that we'll
A company I work with is in the process of upgrading its databases from
some
motheaten system to something current. My impression is that they
want to go with Oracle, and I'm not sure if this is based on anything
other than being impressed with the size and presumed quality support
of Oracle.
: MySQL vs. Oracle (not speed)
A company I work with is in the process of upgrading its databases from
some
motheaten system to something current. My impression is that they
want to go with Oracle, and I'm not sure if this is based on anything
other than being impressed with the size and presumed
Price.
MySQL == Free
Oracle ==
On Thu, 2002-08-15 at 20:25, Elizabeth Bogner wrote:
A company I work with is in the process of upgrading its databases from
some
motheaten system to something current. My impression is that they
want to go with Oracle, and I'm not sure if this is
]]
Sent: 31 August 2001 16:37
To: [EMAIL PROTECTED]
Subject: MySQL vs Oracle vs Acess
Hi
This is a very generic quesiton and I would appreciate
any info. I am an Oracle dba; our developers are now
using access for their own small projects. When these
projects grow and become too large for Access we
I've used all three, Access, Oracle and MySQL. I have the least expertise
with Access.
My impressions are:
* Access is very limited in what it can do with respect to real database
manipulations, those contained in SQL. It does not handle large amounts of
data well. Access is really a very
Hi!
On Wed, Jul 25, 2001 at 10:32:38PM -0600, Chris Bolt wrote:
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
It is totaly useless to compare Oracle vs. MySQL.
Oracle is something you
On Wed, Jul 25, 2001 at 10:32:38PM -0600, Chris Bolt wrote:
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
Also I am looking for
I am currently trying to examine the benefits of continuing to use MySQL
over Oracle. I need to know what MySQL's features are vs. those of Oracle.
Also I am looking for performance data. What kind of scalability does MySQL
have vs. that of Oracle. Is there (or will there be) any support in
I am currently trying to examine the benefits of continuing to
use MySQL over Oracle. I need to know what MySQL's features are
vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
Also I am looking for performance data.
Oracle prohibits benchmarks, so good luck finding them.
for it: MySQL, PostgreSQL or Oracle.
Help us!!!
Sinks in advance.
Nick.
- Original Message -
From: Christian Rabe [EMAIL PROTECTED]
To: Eric Anderson [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 2:27 AM
Subject: Re: AW: mySQL vs Oracle
Sorry, but our
Hi,
Does anyone know of a good whitepaper comparing mysql with some of the other
major databases such as oracle, db2, etc. We are using mysql for most of
our internal work and are trying to push it for some of our project work
with clients and would like to have a nice white paper that outlines
Ann Ricchiazzi wrote:
Dear mySQL Users,
I am trying to choose between mySQL and Oracle for a Linux server. My
specific questions are:
1) Will mySQL handle 3000 hits/day well?
2) Does mySQL handle multi-media file formats? For example, if I want to
store audio clips, or Flash movie
On Mon, 22 Jan 2001 10:49:28 -0800, Ann Ricchiazzi
([EMAIL PROTECTED]) wrote:
Dear mySQL Users,
I am trying to choose between mySQL and Oracle for a Linux server.
My
specific questions are:
1) Will mySQL handle 3000 hits/day well?
I'm on a site that does 90,000 database-heavy pages a day and
Hello Ann,
The answer to you question depends on how you plan to use the database (i.e.
financial trancactions, serving data on the web etc.) as well as financial
considerations. MySQL is free and Oracle is expensive.
Here are some questions you should answer:
1.) Do you need full
"AR" == Ann Ricchiazzi [EMAIL PROTECTED] writes:
AR I am trying to choose between mySQL and Oracle for a Linux server. My
AR specific questions are:
AR 1) Will mySQL handle 3000 hits/day well?
You need to define what a "hit" is. Is it a simple select on the
primary key of a single table or a
]
- Original Message -
From: "Scott Gerhardt" [EMAIL PROTECTED]
To: "Ann Ricchiazzi" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, January 22, 2001 12:10 PM
Subject: RE: mySQL vs Oracle
Hello Ann,
The answer to you question depends on how you plan to us
Sorry, but our mailserver is down again (Exchange ;), so I had to read via
web
and search my list-archiv for your mailadress.
We tested the system on a Dual-P3-800Mhz-1GB while developing.
Now it's running on a E4500 with 6x400Mhz and 8 Slaves (P3-800).
Our site generates currently 1,5-2 Million
97 matches
Mail list logo
