3 ms·
What you say is true; indexing does not make writes faster. In fact, it makes writing to the DB slower, which is why I suggested to turn it off. Now, there may
by carbocation 16y ago
What you say is true; indexing does not make writes faster. In fact, it makes writing to the DB slower, which is why I suggested to turn it off. Now, there may be extenuating circumstances (e.g., you also read from this DB) which make this decision more difficult.
- jongs 16y agoWhy would it make it slower?
- carbocation 16y agoInstead of just inserting a record, it now has to do something else, too (update the index). Try taking a look at http://kevin.vanzonneveld.net/techblog/article/improve_mysql_insert_performance/ http://kevin.vanzonneveld.net/techblog/article/improve_mysql... , which suggests some things you can try. This might be a question better suited for StackOverflow, by the way.
- jongs 16y agothanks