Re: MySQL vs Oracle

2004-06-16 Thread Daniel Clark
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 se

RE: MySQL vs Oracle

2004-06-16 Thread Weaver, Walt
OTECTED] > Sent: 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

Re: MySQL vs Oracle

2004-06-16 Thread Jaime
age - From: "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

RE: MySQL vs Oracle

2004-06-16 Thread Weaver, Walt
i and 9i at the latest patch levels. Applying 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 > >

MySQL vs Oracle

2004-06-16 Thread Jaime
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 consume

mySQL vs. Oracle

2002-10-18 Thread mleary
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 backu

mySQL vs. Oracle

2002-10-18 Thread Sam Bauer
Mike, A lot of my Oracle / MySQL questions got answered by searching the archives at for "Oracle" (so many!) or "Oracle ..." e.g "Oracle Backup" etc. Thanks, Sam Bauer, Oracle DBA - Before posting, please check: http://www

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Mark Matthews
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 c

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Mark Goodge
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:

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Robert Fox
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 tab

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Brent Baisley
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 Ora

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Rodney Broom
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:

RE: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Bryan
;First name",NULL,"Last Name"); -> 'First name,Last Name' -=Bryan=- -Original Message- From: MySQL [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 11:47 AM To: [EMAIL PROTECTED] Subject: Mysql vs. Oracle and concat "||" Hi all,

Re: Mysql vs. Oracle and concat '||'

2002-09-26 Thread Jeff Kilbride
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,

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread sherzodr
: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; - Before

RE: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Andrew Braithwaite
ect: 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

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Jocelyn Fournier
sday, September 26, 2002 8:46 PM 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 ||',

Mysql vs. Oracle and concat "||"

2002-09-26 Thread 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, bu

Mysql vs. Oracle and concat "||"

2002-09-26 Thread 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, bu

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Elizabeth Bogner
dn't mean that speed wasn't 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

Re: MySQL vs. Oracle (not speed) - not part of the rant, but real information

2002-08-16 Thread David Lloyd
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 th

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
t; Sent: Friday, 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, >

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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 the

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
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)

2002-08-16 Thread Aron Pilhofer
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. Oracl

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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 t

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Gelu Gogancea
- Original 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 (n

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
back. -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 pro

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Heikki Tuuri
ight now 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 Stick

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Orr, Steve
as MySQLAB 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 t

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Gelu Gogancea
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 ev

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
: 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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
re not null... > 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) > &g

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Dan Nelson
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 paramete

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Van
his 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) > >

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Jocelyn Fournier
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 pr

Re: improving slow query (was: MySQL vs. Oracle (not speed))

2002-08-16 Thread Benjamin Pflugmann
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

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mark Matthews
nbt a 5 year > one and I am 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] > Subjec

RE: MySQL vs. Oracle (not speed) - not part of the rant, but real information

2002-08-16 Thread Adam Nelson
tickney [mailto:[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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Kenneth Hylton
:53 AM 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 [mail

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Heikki Tuuri
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

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Jocelyn Fournier
MAIL PROTECTED]>; "Mark Matthews" <[EMAIL 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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
D]> To: "Mary Stickney" <[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...

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Jocelyn Fournier
ary Stickney" <[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 c

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
:[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 te

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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 h

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Jocelyn Fournier
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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
Mary 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]&

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Serge Paquin
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 o

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Jocelyn Fournier
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: MySQ

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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 and on

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mark Matthews
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

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Jocelyn Fournier
;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 5:31 PM 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 &g

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
;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

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Jocelyn Fournier
gt;; <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 4:31 PM 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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread John Griffin
al Message- 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.

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
EMAIL 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 ha

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
<= '20020430' 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.

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
), 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

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mark Matthews
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 bac

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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 al

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
: Friday, August 16, 2002 10:36 AM > 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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
]] 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 benchm

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Alec . Cawley
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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
L PROTECTED]] Sent: Friday, 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 projec

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
gt; 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 [mai

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Aron Pilhofer
st 16, 2002 9:53 AM > 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

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Tom Gao
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

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Francisco
; on MS-SQL it took 11 minutes.. > > yes 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. O

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mark Matthews
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 usi

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
; [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-pla

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Francisco
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) > > > > A company I work with is in the process of upgrading > its databases from > so

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Anderson Pereira Ataides
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 f

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Heikki Tuuri
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 yo

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Kent Vilhelmsen
oesn't suport alot of differnt things > it dosent 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:

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Mary Stickney
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 not sure if this is based on anything other than being impr

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread John Griffin
August 15, 2002 10: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 not sure if this is based on any

Re: MySQL vs. Oracle (not speed)

2002-08-15 Thread Matthew Walker
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

RE: MySQL vs. Oracle (not speed)

2002-08-15 Thread Art Fore
: 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 pre

MySQL vs. Oracle (not speed)

2002-08-15 Thread Elizabeth Bogner
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. I'

Re: MySQL vs Oracle vs Acess

2001-08-31 Thread Chris Johnson
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 fan

Re: MySQL vs Oracle vs Acess

2001-08-31 Thread Adams, Bill TQO
Gene Gurevich wrote: > them to Oracle. The developers are now considering > switching from Access to MySQL and I'm trying to > figure out what are the advantages of that move. I Any DB is better than Access for a sizable table. Once access gets to about 100k records in a table it completely bom

RE: MySQL vs Oracle vs Acess

2001-08-31 Thread Simon Green
]] 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

MySQL vs Oracle vs Acess

2001-08-31 Thread Gene Gurevich
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 move them to Oracle. The developers are now considering switching from Access to M

Re: MySQL vs. Oracle

2001-07-29 Thread Peter Holm
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 somethi

Re: MySQL vs. Oracle

2001-07-28 Thread Jeremy Zawodny
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 fo

RE: MySQL vs. Oracle

2001-07-25 Thread Chris Bolt
> 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 the

MySQL vs. Oracle

2001-07-25 Thread Shon Stephens
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 MyS

Mysql vs. Oracle

2001-01-23 Thread Wayne Hefner
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

Re: AW: mySQL vs Oracle

2001-01-23 Thread Nick Kostirya
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

Re: mySQL vs Oracle

2001-01-22 Thread Mike Gohlke
At 10:49 AM 1/22/2001 -0800, Ann Ricchiazzi quoth: >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? Yes, over the last 219 hours one of my servers has been averaging 55.417 queries/sec

Re: AW: mySQL vs Oracle

2001-01-22 Thread Christian Rabe
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

Re: mySQL vs Oracle

2001-01-22 Thread Nathan Cook
To: "Nathan Cook" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, January 22, 2001 2:42 PM Subject: Re: mySQL vs Oracle > > er, what? > did i miss something? heh. > > -tcl. > > > On Mon, 22 Jan 2001, Nathan Cook wrote: > > > Note: As of

Re: AW: mySQL vs Oracle

2001-01-22 Thread Eric Anderson
On Mon, 22 Jan 2001, Christian Rabe wrote: > we use mysql here for our whole site. there are up to 500 > inserts/second alone from the stockdata-feed and thats only part of > our site and about 200-300 selects/second per machine. in > combination with replication (3.23.xx) you can near to limitle

Re: mySQL vs Oracle

2001-01-22 Thread Steve Ruby
Nathan Cook wrote: > > Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. See... I know I've been spending too much time at the computer when I get email in my dreams :) what version are you talking about anyway, that number isn't even a valid version number.. -

Re: mySQL vs Oracle

2001-01-22 Thread tc lewis
ager - 208.387.9983 ] > > - 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 > &

AW: mySQL vs Oracle

2001-01-22 Thread Christian Rabe
[mailto:[EMAIL PROTECTED]] Gesendet: Montag, 22. Januar 2001 19:49 An: [EMAIL PROTECTED] Betreff: mySQL vs Oracle 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

  1   2   >