hi
This is not a critisism in any way - rather a query regarding table types: MyISAM & INNODB resp. Part two of the good book we get into some advanced MySQL i.e. stored procedures. The procedure (well the first anyway) I'm curious about is:
select_sale_items(get_all BOOLEAN)
I'm not a MySQL expert by any means so am appealing to the RDBMS gurus really. My question is regarding table locking. What if my database has 1000 records in the sales and non_coffee_products tables say. Then 3000 people log on to my site and all head for the sales page simultaneosly.
The tables in the procedure above are of type MyISAM and MyISAM locks tables whilst INNODB locks rows. Will this cause problems in my hypothetical scenario?
I ran
get_sale_items(true)
at home with six records in the database and it executes in (0.00) sec, fast! Would a production version differ significantly?
Would the query make it to the MySQL slow-query.log with a slow query being > 1 sec?