> 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 the logic of your program and changed
> the specification in oracle?
There was no change in the logic. However the facility of subqueries in
Oracle did reduce the no of requests.
> BTW what is the cost of oracle on Linux? MySQL is free
> :)
> Also is there difence in coding effort involved?
>
Not much effort difference in the coding effort.
Yes, Mysql is free but Oracle (Single CPU 5 User license) also does not cost
hell lot of money.
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 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.
What do you say.
Kapil Sethi
System Administrator
BharatConnect Ltd.
Ph: 011-6430147
================================================
To subscribe, send email to [EMAIL PROTECTED] with subscribe in subject header
To unsubscribe, send email to [EMAIL PROTECTED] with unsubscribe in subject header
Archives are available at http://www.mail-archive.com/ilugd%40wpaa.org
=================================================
