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? MySQL is free :) Also is there difence in coding effort involved? Lokesh --- Kapil Sethi <[EMAIL PROTECTED]> wrote: > > 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 msql or postgress SQL > is > > being used on a server with similar load. > > I belive the performance will depend on the > > application and the genral load on the server. > > > > Would Oracle perform beter on similar load > conditions > > and with similar amount of data? > > Well Lokesh, > > My experience with both Mysql and Oracle says that > Mysql cries when put > under the same load conditions as compared to oracle > on the same hardware. > > My programmer team had to write a couple of websites > again from scratch in > oracle just because Mysql was not able to handle the > load. > > I personally feel that Apache-PHP- Oracle8i is > faster under heavy load as > compared to Apache-PHP-Mysql. On the same hardware, > and OS. (I have Oracle8i > (8.1.6) on Linux ) > > > 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 > > ================================================= > __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com ================================================ 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 =================================================