Hi guys..

I was told that different database engines have got different performance.... is it true??

i.e. if i have a table with say 20000 entries (rows)... if i create the same table say on Oracle and SQL Server and perform the same query on both engines... does retrieve performance i.e. execution time varies...


what are the key factors that determine performance??


regards

Yes, performance varies among databases. For example Acces is fine for smaller databases and more industrial-grade databases like SQL Server, MySQL, and Oracle are better for larger databases.

MySQL is more bare-bones tables than MySQL thus it's often considered faster but has less features which some advanced developers might use.

But another nice thing about MySQL is the price - basically free (open-source).