> 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 operations. And in my view Oracle is much faster because of better disk caching it employs and I hope that this is the most important factor. > > Though query optimization also does help when there are complex queries. I guess that here we come to the same problem. Oracle has 100s of features that are not there in MySQL and some of them combine together to give better performence!
Bye, /\ |\/| |3 /\ r ================================================ 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 =================================================