> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes:
Ambar> [snip]
>> We used to have a chap called Neil whom you'd have gotten along
>> well with :-)
Ambar> Yeah, I do remember Neil ;) BTW.. where is he nowadays?
Last I heard he was at some German University. I think he's lu
> >> Boss, how about writing in English for a change? I must
> >> confess that I skip over all your posts because they're
> >> impossible to read even though you appear to be talking useful
> >> stuff.
>
> Ambar> I was under the impression that I was writing in some
> Amb
> >Doesnt oracle9i come with a minimum 5 pooter license these >days ?
> >Perhaps they realised, nobody will buy oracle for a single PC.
> Oracle 8i & 9i is a free download for non commercial use and evaluation.
and it is not time bound as well. So you can have > your personal benchmarks
and then
>Doesnt oracle9i come with a minimum 5 pooter license these >days ?
>Perhaps they realised, nobody will buy oracle for a single PC.
Oracle 8i & 9i is a free download for non commercial use and evaluation. and it is not
time bound as well. So you can have your personal benchmarks and then comm
> >> Can some one tell me the exact cost of oracle on Linux?
> amit> Should be close to $30,000.
> amit> Approximatly the amount in which you could buy 5 servers and
> amit> hire raju for 30 minutes to setup load balancing and fine
> amit> tune all the servers. ;o)
> I object -
> "amit" == amit soni <[EMAIL PROTECTED]> writes:
>> Can some one tell me the exact cost of oracle on Linux?
amit> Should be close to $30,000.
amit> Approximatly the amount in which you could buy 5 servers and
amit> hire raju for 30 minutes to setup load balancing and fine
> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes:
>> It Looks that most of the people are ignoring a very important
>> that it is
Ambar> the amount of I/O with a DBMS is doing. If for the same
Ambar> type of repeated operations i.e. adding of UNIQUE records
Ambar> to a ta
> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes:
>> Boss, how about writing in English for a change? I must
>> confess that I skip over all your posts because they're
>> impossible to read even though you appear to be talking useful
>> stuff.
Ambar> I was under the imp
> Can some one tell me the exact cost of oracle on
> Linux?
Should be close to $30,000.
Approximatly the amount in which you could buy 5 servers and hire raju for
30 minutes to setup load balancing and fine tune all the servers. ;o)
T
s, we did all tuning
ourselves with no vendor input.
Damn its almost the whole thing i pasted in here !
So... .does everyone like MySQL now ?
regards,
Amit.
- Original Message -
From: "Vipul Mathur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursd
In next Linux meet, a force graduation for Raju on Internet shortcut
***lingo***.
> Ambar> procedures :) There are lots of other reasons.. (like for
> Ambar> e.q. i might be getting Oracle for free, or your dba knows
> Ambar> only oracle , etc)
>
> Boss, how about writing in English f
> There may be some difficulty in defining how small
> is "small" and how
> large is "large". There would also be many other
> considerations like kind
> of information being stored in the database,
> complexity of the relations
> between tables etc..etc which goes into
> decisions on wha
> Again, I have no clue _why_ or even _if_ Oracle is "faster", just that the
> simpler solution need not be the "better" solution.
The following links should help:
Server Databases Clash
http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp
MySQL vs Oracle
http://www.geocrawler.com/mail/
> It Looks that most of the people are ignoring a very important that it is
the amount of I/O with a DBMS is doing. If for the same type of repeated
operations i.e. adding of UNIQUE records to a table with few lakh records is
to be done then the faster DBMS is the one which will require lesser I/O
At 01:32 PM 5/2/2002, you wrote:
>I don't see where this discussion is headed. The basic difference between
>Oracle and mySQL would be in the area of Query Optimization. Probably, this
>And probably, that is why Oracle costs money. mySQL is a good database for
>small applications. Before using
It Looks that most of the people are ignoring a very important that it is the amount
of I/O with a DBMS is doing. If for the same type of repeated operations i.e. adding
of UNIQUE records to a table with few lakh records is to be done then the faster DBMS
is the one which will require lesser
> Boss, how about writing in English for a change? I must confess that
> I skip over all your posts because they're impossible to read even
> though you appear to be talking useful stuff.
I was under the impression that I was writing in some english dialect! Can
you please tell me how I can impor
> "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes:
Ambar> First thing, ferrari engines are not always used in race
Ambar> tracks. U do get ferrari road cars that u can drive on
Ambar> delhi roads. It is a different matter that u wud be
Ambar> extremely irritated when u drive a
> > > supports is better memory management?
> > Last time i checked, MySQL didn't hav any built in caching algorithm.
That
> > was 3.22.xx version series. For disk caching MySQL depends on the OS,
and
> Was in their todo list in last year, should be done by now.
So was sub selects & stored procedu
> Exactly you cannot compare ferrari engine with fiat
> palio's. You can only compare them if they perform the
> same function. you need a ferrari for race tracks and
> palios for delhi roads. Why would you put ferrari on
> delhi road when you know there will be red light and
> other traffic probl
Hi,
> Do triggers, trans, foreign keys and rest 1996 things etc also improve
speed
> ?
a lot of things improve performence, if used properly! Transactions are
something that u need for a lot of applications, and they are also supported
by MySQL in some table types ;)
> So, apart from sub-querie
- Original Message -
From: "amit soni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 02 May, 2002 1:56 AM
Subject: Re: [ilugd]: MySQL evaluation
>
> > Maybe one of the 2000 is a querry optimiser? Or one of the "many
things"
>
Hi,
I don't see where this discussion is headed. The basic difference between
Oracle and mySQL would be in the area of Query Optimization. Probably, this
is the most critical phase which distinguishes from one DBMS to other. And
Oracle has a wonderful Query Optimizer. Query Optimization is a ver
> Well, actually the difference is that the hardware
> are not same... Both may be car's but
> the engines are different. You can't compare a
> ferrari engine with fiat palio's engine!
> Though both burn fuel and rotate a shaft. Those
> '1999' other things that go into ferrari
> engine makes the d
Think u read it all rong.
The car drivers are the database engine.
Computer hardware is the car.
now?
> > The shortest road between two points is a straight line.The person
driving
> > on the zig-zag road will always loose.
> > Even if he is a much better driver, he has those extra turns to hand
> > supports is better memory management?
> Last time i checked, MySQL didn't hav any built in caching algorithm. That
> was 3.22.xx version series. For disk caching MySQL depends on the OS, and
Was in their todo list in last year, should be done by now.
So using OS cache is not as good as havin
> The shortest road between two points is a straight line.The person driving
> on the zig-zag road will always loose.
> Even if he is a much better driver, he has those extra turns to handle too.
> He can never beat the straight road driver on the same hardware. Even if the
> hardware load is a
> Maybe one of the 2000 is a querry optimiser? Or one of the "many things"
it
OK accepted, perhaps sub queries make things faster.
Is it because the result set doesnt have to travel back and forth from
application to db server again and again ?
Do triggers, trans, foreign keys and rest 1996 thi
On Thu, May 02, 2002 at 11:37:31AM +0530, Ambar Roy spoke out thus:
> > What does top show on
> > both the computer in similar load condition. That is
> > what needs to be checked i guess.
> my experience with heavily loaded linux server tells me that never use top
> on any server that is heavily
> What does top show on
> both the computer in similar load condition. That is
> what needs to be checked i guess.
my experience with heavily loaded linux server tells me that never use top
on any server that is heavily loaded. top tends to eat up a lot of resources
:(
Bye,
/\ |\/| |3 /\ r
> > MySQL uses the simplest and most straight forward thread controls. It
has
> to
> > be faster ! Oracle should be slower!!
> > Oracle has probally 2000 extra things to protect oracle from crashing,
and
> > its programs are much larger than MySQL, since it is supposed to support
> too
> > many th
> The Mysql System with apache has 256 MB RAM and The
> Oracle machine is 128
> MB, both on a PIII 500 MHz, 20 GB EIDE HDD. The same
> database the same table
> structure, approx 2 lakh records in one table ( a
> user registration table)
> which is used to store User details. If 10 user
> register
From: "amit soni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 4:31 PM
Subject: Re: [ilugd]: MySQL evaluation
> MySQL uses the simplest and most straight forward thread controls. It has
to
> be faster ! Oracle should be slower!!
>
> which is used to store User details. If 10 user register on the site
> simultaneously the mysql server almost freezes. [I mean to say that the
> mouse barely moves on that machine] and when I am testing the same with
> oracle I does that happily.
may its your mouse or mouse pad. ;o)
MySQL uses
> What could be the reason for oracle doing better that
> mysql with the same load and same hardware?
> Or is it that the logic used by oracle to manage data
> is better than mysql?
I think Oracle has a better memory management, data management, and caching
system than mysql.
> Did you change t
What could be the reason for oracle doing better that
mysql with the same load and same hardware?
Did you change the logic of your program and changed
the specification in oracle?
Or is it that the logic used by oracle to manage data
is better than mysql?
BTW what is the cost of oracle on Linux
What could be the reason for oracle doing better that
mysql with the same load and same hardware?
Did you change the logic of your program and changed
the specification in oracle?
Or is it that the logic used by oracle to manage data
is better than mysql?
BTW what is the cost of oracle on Linux
> I feel that mysql is a very good database. If it is
> free and so good why compare with something that costs
> money. With small size of data its performance is
> great.
> One thing that i wonder is if I have the same amount
> of data say 2GB would there be significant difference
> in performanc
I feel that mysql is a very good database. If it is
free and so good why compare with something that costs
money. With small size of data its performance is
great.
One thing that i wonder is if I have the same amount
of data say 2GB would there be significant difference
in performance in mysql or
> I would say that if one is looking for complexity and scalability of RDBMS
> in the open source world, Postgres is a good choice. Though I am not too
> confortable with the pace of it's development.
~
Exactly !
I am sure when enough experiments are
At 08:11 AM 5/1/2002, you wrote:
>MySQL is great, for example, for the typical web-hosting provider who
>usually needs a small RDBMS which would accomodate a few hundred
>databases with a few thousand records each.
I can see that it is indeed very popular amongst such providers.
And I also agre
> Leo> transactions. Though, I do hear that MySQL has been deployed
> Leo> at a few centres with prominent names. Essentials like
> Leo> transaction support, stored procedures and the like were not
> Leo> there in earlier versions and while some things are changing
> Leo> in th
Hi Leo,
> "Leo" == Leo Fernandez <[EMAIL PROTECTED]> writes:
Leo> Raj, The write-up on MySQL though a bit dated does raise
Leo> well-known issues. I have always failed to get any impression
Leo> that MySQL was designed for high-end, large enterprise-level
Leo> mission-critica
Raj,
The write-up on MySQL though a bit dated does raise well-known issues. I
have always failed to get any impression that MySQL was designed for
high-end, large enterprise-level mission-critical database management
applications with potentially hundreds and thousands of simultaneous
transa
44 matches
Mail list logo
