I get the error - "sqlite3.OperationalError: too many SQL variables"
Yet if I search as follows:
`cls = onto.search_one(label='afar')`
The search works. This error isn't consistent though - the Class `afar` happens to have a Parent Class with many Subclasses and a lot of nesting within the Subclasses, but in some cases the search works well when the Parent Class doesn't have many Subclasses with nesting, so I wonder if the size and complexity of my Ontology is the issue but in that case, what can I use to perform the search (it's important for me to search in this specific way)?
Re: Error when searching the ontology : "sqlite3.OperationalError: too many SQL variables"
I think this problem occurs when cls_parent has more than 999 descendants classes. In the current implementation of search, each descendant classes requires an SQL variable, and they are limited in SQLite.
I've written a different implementation in the development version of Owlready on BitBucket, using recursive SQL queries. It is no longer limited by the number of descendant classes, and is also be faster. Could you verify if it work well now, please?