Large MySQL Data Imports

Published on

Disable MySQL indexes MySQL can import many rows with a single disk write. It makes the import go many times faster and minimizes the impact on other customers. Database files created with phpMyAdmin or mysqldump already contain commands to disable the indexes. To disable MySQL indexes: Add these commands before the import starts: ALTER TABLE … Continue reading Large MySQL Data Imports

SQL vs. NoSQL

Published on

NoSQL is an alternative to SQL, not a replacement. SQL databases include MySQL, PostgreSQL, SQLite and Oracle. NoSQL databases include MongoDB, CouchDB, Redis and Cassandra. Your requirements should determine the database type — not the language. SQL NoSQL Design is rigid Design is flexible Schema must be defined Data can be added anywhere Normalized data … Continue reading SQL vs. NoSQL