database change

[Muk108]

how hard will it be for me to change my database from mysql to oracle? or if anyone has any sujestions about wheater or not i even need to move to oracle. right now im working on a shopping cart for a company but we are also planning on getting a new POS system and do you guys think i need to move them from mysql to oracle or could i leave it all in mysql or should i keep the website as mysql and have the pc application for the POS system in oracle and connect the to via some api to make sure they are both up todate with one another?

[penagate]

Don't feel that you should have to move database systems because MySQL is a very capable database system and very well integrated with PHP so unless you need some special feature of Oracle that MySQL does not offer I would suggest that you stick with MySQL and also some punctuation would help in order to avoid long run-on sentences like this.

[Muk108]

sorry :) i was just typing how i thought. but anyway what about speed of an application? if i am using this database for not only my website but my system application? how does the speed of oracle's stored procedures/functions compare to always using sql statments? im trying to consider what would be the best for the company that is dealing with a lot and lot of data...mabye 50,000 plus entries in just the products. i knwo thats not too much but how would the speed compare between the two?

[HoraShadow]

50.000 records is nothing to a database engine like MySql or Oracle. We are talking about a difference of miliseconds between both dbs.

You use oracle when your numbers are in the tens of millions of queries per day. That's one of the reason why it costs that much.

To give you an example, with 50.000 records, you can use Ms.Access and it will perform almost as well.

HTH
HoraShadow

[Muk108]

even with complicated queries?

[HoraShadow]

google uses mySql cluster as database. So yeah, it will handle it.

[Muk108]

well then what would be the advantage for people to want to use oracle? can can it do that mysql cant.

and i know this is now turning into a database question sorry if its getting off topic, but its still kind of related :)

[Matt_T_hat]

I have a trick that will get things sorted in my head nintynine times out of one hundred.

Make a list (on paper or in head) of everything I want/need and then see what the leding solutions can do. When you find one that meets all your needs/wants fully use it and don't worry about the others.