I'd like to thank everyone for giving such helpful and detailed
responses;
it's the sort of thing that shows me how good the support here can be!
I did want to address some things that may not have been clear enough
in my original message. When I said "not speed" I didn't mean that speed
wasn't
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
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,
>
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
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 but
> this column
> is not indexed.
> Please tell me if an index on this column improve the speed of the
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
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
- 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
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
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
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
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
: 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 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
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
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)
>
>
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
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
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
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
: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
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
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
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...
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
:[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
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
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
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
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]&
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
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
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
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
;[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
;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
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
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.
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
<= '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.
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
),
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
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
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
: 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
]]
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
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
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
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
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
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
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
; 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
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
; [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
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
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
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
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
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
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
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
: 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
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'
64 matches
Mail list logo