Quote
Hundreds of identical tables?
No, there are 24 identically structured tables. All of their field names are unique except for the first two, 'id' and 'userid'.
Is the design bad? I don't know enough about database design to have an opinion. However, the application does work. The goal of my application is to help students learn a core vocabulary of 4,200 words and to confirm each student's understanding of each word in the vocabulary.
Quote
`id` tinyint(6) NOT NULL auto_increment,
That won't let you have more than 127 rows. Is that deliberate?
No, it's a stupid mistake caused by ignorance. I will change 'id' and 'userid' to bigint(10).
Quote
Kill phpMyAdmin and restart MySQL
That is not an option with my shared hosting control panel.
Quote
Plan A:
SET optimizer_search_depth = 2;
Plan B:
STRAIGHT_JOIN
Thanks for these suggestions. I will give them a try.
Quote
Plan C:
Abandon Moodle.
The version of my application that I linked to at
http://www.thewordmap.com/topic.php is actually running on a simple
http://www.maaking.com/ membership application. The same query caused a database crash with a join to its maaking_user table.