artacus Posted February 1, 2007 Share Posted February 1, 2007 When I started working with MySQL I was amazed at how quickly it could rip thru 100,000 records, joining dozens of tables in the process. Now that the novelty has worn off, I find working with most other databases unbearably slow. Not Oracle, but just about every other proprietary database. And I guess I've worked with some odd ball db's that probably none of you have even heard of like Progress and Pervasive. Anyhow, right now I'm working on data extraction from a Progress db. And so as I'm running a query that takes 20 minutes to run, I'm thinking I'd bet my paycheck that MySQL could have ran the same query in under 30 seconds. So my question is this. Has it been your personal experience when working with other db servers that maybe you're spoiled due to MySQL? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 1, 2007 Share Posted February 1, 2007 To be honest, I've never touched another RDBMS... but I'd imagine that all of the shortcuts that MySQL takes (e.g. MyISAM vs InnoDB) account for at least some of that difference. Quote Link to comment Share on other sites More sharing options...
artacus Posted February 1, 2007 Author Share Posted February 1, 2007 Well some of the syntactical shortcuts are good (LIMIT, GROUP_CONCAT) and some probably encourage sloppy coding ( using LIKE on an INT column ) Most other databases are much more strict with what you can do with different data types. Then again most programming languages are much more strict than PHP when it comes to this, so maybe its just an all around good fit. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 1, 2007 Share Posted February 1, 2007 I wouldn't run a financial system (like a bank) off of mysql, but I've used it for just about everything else. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.