Johannes Klarenbeek <[email protected]> wrote: > Dear sqlite users and developers, > > my question is why doesn't sqlite support recursive selects yet... is there > a practical reason behind it perhaps? > > Many projects that I dealt with have a sort of parent child relationship in > some of their tables. There is a lot of overhead in resolving these parent > child path queries remotely
What do you mean, "remotely"? With SQLite, the database engine sits in the same process with your application. SQLite cannot perform a set of queries necessary to traverse the tree any faster than your application can. > And client side caching is not always an option in > case of huge databases. Client side of what? What other side is there? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
