D
dbeavon
Guest
>> I don't see that you have told us any reason why you don't just set up an extra local OpenEdge database on each server, to use instead of your temp-tables? Why not more OE databases? That involves lots of overhead/infrastructure, persistent schema, security considerations, licensing, etc. SQLite is free of any these considerations. Moreover, with SQLite-based temp tables you would get some additional benefits that I had mentioned: you would also be able to run SQL queries against them, or transfer the connection to the database file to a different (non OE) application in order to do follow-up analysis. Getting large amounts of OpenEdge data to move from one tier to another can be expensive. Depending on how the ABL is written, this can be more expensive for "client/server", than when using the SQL92 driver. But after that initial expensive is paid, then SQLite-based temp tables can "preserve" the investment, and retain data for later use. The data could be portable, flexible, and far less "transient" than normal TT data which is immediately lost after the client session ends.
Continue reading...
Continue reading...