Copyright (C) 2000-2012 |
GNU Info (mysql.info)Design LimitationsMySQL Design Limitations/Tradeoffs ---------------------------------- Because MySQL uses extremely fast table locking (multiple readers / single writers) the biggest remaining problem is a mix of a steady stream of inserts and slow selects on the same table. We believe that for a huge number of systems the extremely fast performance in other cases make this choice a win. This case is usually also possible to solve by having multiple copies of the table, but it takes more effort and hardware. We are also working on some extensions to solve this problem for some common application niches. automatically generated by info2www version 1.2.2.9 |