Looking at the query log dosent seem right, or am I missing something?
When I execute this code:
it returns two records from a table that has only 7 records in it, yet the #of queries reported jumps from 336 to 423Code:$md_sql = "select * from m_data where md_ID = " . $master_ID; $movie_data = $db->Execute($md_sql); if ($movie_data->RecordCount() > 0) { while (!$movie_data->EOF) { echo '<p>Title: ' . $movie_data->fields['md_title'] . '</p>'; $movie_data->MoveNext(); } }
Does it really take 87 queries to select two records out of seven? Or is the way the queries are counted wrong? Or am I doing something wrong?
Yes, the table is properly indexed.
If it's true, is there any way to make this more reasonable?



