If I remember correctly from the certification guide, MySQL opens a
file handle for each table opened. When you have a MyISAM table,
that's one file handle each for the structure, data and index files.
So if you have a query that uses only one table, it can spawn up to 3
file handles.and
Hi!
We have that huge query against a mysql 4.1 (myisam) to retrieve rows.
The query is built dynamically using a loop, as we are searching in an
external database built to store a tree with the nested tree model.
When we do this search with a normal world, it's fine: the query is around
4