In the last episode (Mar 10), Brent Clark said:
> Hiya
>
> I just found that I can run
> mysql db -e 'source exporteddbdata.sql'
>
> The question I would like to ask is. Is there a speed difference between
>
> mysql db < exporteddbdata.sql
> and
> mysql db -e 'source exporteddbdata.sql'
> (usi
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), "Robert P. J. Day"
wrote:
> no, i don't want to start a flame war, i just want some feedback on
> a current list of mysql "drawbacks" WRT postgresql.
>
> in the context of a fully open-source, java based ECM product, there
> is a FAQ entry that summarize
On Thu, 4 Aug 2005 23:36:01 -0700 (PDT)
David Blomstrom <[EMAIL PROTECTED]> wrote:
> I wondered if anyone on this list has had experience
> with Plone and could explain how their system compares
> to PHP/MySQL. I'll be working with animal kingdom data
> - child-parent relationships and recursive a
Wow, this is turning into quite a research project.
Thanks for the tip about ontologies; it doesn't make
much sense to me yet, but I'll take a closer look at
the article.
In the meantime, I'm thinking of using a content
management system called Plone. Unfortunately, I've so
far been unable to inst
That's an excellent paper. However, David (the OP) is not actually in
control, nor is he designing his ontology He is attempting to build a
persistence/retrieval system for the taxonomy (ontology) that the
scientific community has already created to categorize life on our planet
(Kingdom, Phylu
May be you should consider building an ontology with your data base. This links
will provides ideas to explore this avenue:
http://www.ksl.stanford.edu/people/dlm/papers/ontology-tutorial-noy-mcguinness-abstract.html
Raoul
David Blomstrom <[EMAIL PROTECTED]> wrote:
I've been gathering data for
Thanks for all the tips. That makes it much clearer. I
think I'll stick with PHP and MySQL and gradually
introduce a little XML if it fits in.
I just downloaded a content management system called
Plone, which is supposed to be a good choice for
hierarchical databases.
_
Hi ,
First of all it should be clear that XML is only a well organised
representation of data a mere text file.
It is not a software . U will have to append entries all by urself to
the file, and marking up suitable tags ( say the attribute of ur
relational table) .
Data will have to be extracted
MySQL is a relational database. XML is a text file.
the biggest difference is that MySQL will let you organize, sort,
match/link (joins), and otherwise manipulate the data you have. XML is
just text with tags in a heirarchy; anything other than reading it in a
text editor will take programming
Rhino,
Martin Hubel's company is dedicated to DB2. A different bias would've
been amazing :-) .
PB
-
Rhino wrote:
Oops, sorry, forgot the URL ;-)
ftp://ftp.software.ibm.com/software/data/pubs/papers/db2_mysql_comparison.pdf
Rhino
- Original Message -
From: "Rhino" <[EMAI
Oops, sorry, forgot the URL ;-)
ftp://ftp.software.ibm.com/software/data/pubs/papers/db2_mysql_comparison.pdf
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Saturday, April 09, 2005 3:28 PM
Subject: MySQL vs. DB2
> I just came across this comparison of
On Tue, 15 Mar 2005 18:49:38 +0900
ninjajs <[EMAIL PROTECTED]> wrote:
> What do you think about MySQL vs PostgreSQL ?
Both are great products and have their ups and downs. On a MySQL list
you will not get an un-biases answer to this question.
If you really want to know what people on the MySQL
Perhaps a quick search at a list archive will give you the answers you
are looking for. This was discussed at length about 6 months ago and the
messages are still at gmane. Just page through and you will find many
messages with just this subject.
http://search.gmane.org/search.php?group=gmane.comp
Hello.
You should search in archives for such questions. For example see
threads at:
http://lists.mysql.com/mysql/160972
http://lists.mysql.com/mysql/170673
"shabanip" <[EMAIL PROTECTED]> wrote:
> hi,
> just want to know the main benefits of mysql over postgresql.
> thanks,
On Fri, Feb 25, 2005 at 06:43:50PM +0100, Jochem van Dieten <[EMAIL PROTECTED]>
wrote:
>
> Don't you think it is childish to link to documentation from 2003?
I've never seen a child do anything like you describe.
-Rich
--
Rich Lafferty --+
On Fri, 25 Feb 2005 11:21:26 -0600, mos wrote:
>
> http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/MySQL-PostgreSQL_features.html
There is a reason this page was removed from the MySQL site: some of
it was never correct in the first place, and the rest was severly
outdated.
Don't you thi
At 05:45 PM 2/24/2005, you wrote:
hi,
just want to know the main benefits of mysql over postgresql.
thanks,
Payam Shabanian
Payam,
The differences between the products are narrowing, especially
with MySQL 5.0 which is still in beta. If I could sum it up in 1 sentence
then MySQL is typical
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
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
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
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 and it's easy to make it run badly.
We run customer databases on both MySQL and Oracle, using a product
developed on MySQ
Simon Windsor <[EMAIL PROTECTED]> wrote:
>
> I have recently upgraded from mysql vs 4 to 4.1 and have noticed that the
> output format in mysqldump has changed a lot, using a single insert statement
> to populate a table.
>
> Is there anyway I can use mysqldump to produce a single insert statem
The real name of the rpm package should be inside the .spec file
contained within the rpm file.
Best Regards!
On Tue, 2004-03-02 at 17:53, David Quenzler wrote:
>
>
> My machines have several mysql RPMs installed as part of a SuSE UL 1.0 base
> configuration.
>
> RPMs are all lower-case of th
avid.
- Original Message -
From: "Matthew" <[EMAIL PROTECTED]>
To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, December 04, 2003 4:18 PM
Subject: Re: MySQL vs. MaxDB
>
>
> from http://www.mysql.com/press/release_20
from http://www.mysql.com/press/release_2003_35.html
"The MySQL database is a high performance relational database management
system that is noted for its speed, stability and ease of use, while MaxDB
is certified for SAP applications and includes features such as stored
procedures, triggers and
really, Delphi to MySQL is just like Delphi to Paradox,
> or Oracle or any thing else just get the drivers and off you go :-)
>
>
> - Original Message -
> From: "Bill Hess" <[EMAIL PROTECTED]>
> To: "William IT" <[EMAIL PROTECTED]>
&g
PROTECTED]>
To: "William IT" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 12:56 PM
Subject: Re: MySQL vs .NET
: If you are using Perl, take a look at SOAP::Lite - do not let the name
: fool you... www.soaplite.com Combining this with Apache
If you are using Perl, take a look at SOAP::Lite - do not let the name
fool you... www.soaplite.com Combining this with Apache and mod_perl
and given Perl can directly interface with MySQL using Perl's DBI (and
also the countless other modules available on CPAN) we have found this
to be a v
MySQL has posted a very interesting comparison on their website. It appears
to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some
areas and MySQL was faster than PostgreSQL in most areas.
For speed with all of that functionality, I'd be more inclined to look at DB2
rat
Hi!
First of all, if I decide to benchmark MySQL vs. PostgreSQL with my
application, PostgreSQL will probably be faster. That does not mean that
MySQL is "generally" slower or that I *want* it to look slower. That
just means
1) I have no experience in tuning MySQL
2) My application was built wi
> As a minor side issue, we did some _very limited_ testing with MS SQLServer
> 2000 using unicode v ascii queries. Using unicode, queries tended to run at
> about half the speed compare to using ascii.
> This was client server, so it is likely that the increased network traffic
> is to blame, but
> > If maximum speed is critical.
> >
> > It's easy to lose sight of the fact that speed is not the
> > only criterion
> > in choosing a DBMS. Features, stability, security, and so on can be
> > just as important or more so. No single DBMS is going to win all the
> > prizes; the trick is to
same environment and network conditions, mainly, using IPv6
network protocol.
Robson
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 2:12 PM
Subject: RE: MySQL vs. PostgreSql -- speed
When I benchmarked PostgreSql against MySql for my application, MySql was 15
times faster, so 18% wouldn't make much difference for me!
Andy
> -Original Message-
> From: Robson Oliveira [mailto:[EMAIL PROTECTED]
> Sent: 14 July 2003 15:35
> To: [EMAIL PROTECTED]
> S
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
> >I agree with your opinion in 100%, but in my case I need DBMS with
> >features like subselectes/utf-8/stored procedures but the
> speed is also
> >very important issue.
>
> You might have to spend money!
>
>
You are saying that there is DBMS with all this features and it is as
fast as MySQL
>> If maximum speed is critical.
>>
>> It's easy to lose sight of the fact that speed is not the
>> only criterion
>> in choosing a DBMS. Features, stability, security, and so on can be
>> just as important or more so. No single DBMS is going to win all the
>> prizes; the trick is to find th
Very smart your opinion, I agree at all with you.
-Mensaje original-
De: Bruce Feist [mailto:[EMAIL PROTECTED]
Enviado el: Monday, July 14, 2003 5:37 AM
Para: MySQL List
Asunto: Re: MySQL vs. PostgreSQL -- speed test
Marek Lewczuk wrote:
>For everyone who thinks about moving from My
>
> which PostgreSQL version have you testet? If you want compare
> MySQL and
> PostgreSQL, than you have to use InnoDB tables. Tests with
> MyISAM make no
> sense. Out J2EE Application is working woth PostgreSQL 7.3.3
> and MySQL
> 4.0.13 with InnoDB tables (we need transactions and
> refe
> If maximum speed is critical.
>
> It's easy to lose sight of the fact that speed is not the
> only criterion
> in choosing a DBMS. Features, stability, security, and so on can be
> just as important or more so. No single DBMS is going to win all the
> prizes; the trick is to find the one
Marek Lewczuk wrote:
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth.
That's a bit of an overstatement!
Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought
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
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:
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
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
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:
Concat and Concat_WS from the mysql web site
CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments.
Returns NULL if any argument is NULL. May have more than 2 arguments. A
numeric argument is converted to the equivalent string form:
mysql> SELECT CONCAT('My', '
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,
: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
Hi,
You need to use :
Select concat(numer,',',test) from table;
See: http://www.mysql.com/doc/en/String_functions.html for more.
Cheers,
Andrew
-Original Message-
From: MySQL [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 26 September 2002 19:47
To: [EMAIL PROTECTED]
Subject: Mysql
Hi,
Well, why not trying... concat() :)
SELECT concat(numer,',',text) FROM Table;
http://www.mysql.com/doc/en/String_functions.html
Regards,
Jocelyn Fournier
- Original Message -
From: "MySQL" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 8:46 PM
Subj
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
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:
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
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
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: Friday, August 16, 2002 11:34 AM
To: Mary Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs
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
lto:[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 and it is a
> very good choice if you don't r
1 - 100 of 184 matches
Mail list logo
