D
dbeavon
Guest
The market *is* there for OE-SQL92, and the technology is already pretty good, having matured a lot since the 9.x days. A lot of people use it for reporting applications. Unfortunately the technology is not not easily accessible from the ABL side of things, which seems strange to me. It sounds to me that some of the problem might be a mistrust of a DBMS to do the query optimization work of a "hardcore developer". There shouldn't be so much anxiety on this point. As I said *many* DBMS products, OE-SQL92 included, are capable of building high-quality query plans from cost-based optimization. I'm still leaning towards an approach that shells out to "sqlexp" and builds a result keyset for ABL to consume. That maybe the best option at this point, especially for those of us who already have a well-established OE-SQL92 infrastructure. As ugly as it sounds, it seems better than a home-grown (roll-your-own) query optimization engine... (but props to those who attempt it...)
Continue reading...
Continue reading...