joined:Jan 12, 2006
I have a MySQL database with several tables. One table in particular will receive constant INSERTS. For example, the table will start with 10 rows, but will grow to 500+ rows as users add more content.
This table will also be queried often with a SQL statement to view the contents of the table. The number of users adding content will be small (approximately 25 users), but I am concerned about multiple INSERT operations clashing with multiple SELECT operations. Even though the number of users will be small, I think there will possibly be dozens of simultaneous INSERTS.
Should I leave table-level-locking to MySQL, or explicitly use the LOCK TABLE code to lock the table during INSERTS?
Also, will using a VIEW help avoid conflicts?