[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Use-index prevent multiple brackets: documented?

  • Thread starter Thread starter Stefan Drissen
  • Start date Start date
Status
Not open for further replies.
S

Stefan Drissen

Guest
A few years ago, prior to the recent single-shot query DataServer adjustments, we adjusted our report engine to use send-sql-statement to send the sql statements directly to the database allowing database join resolution. We implemented this for both Oracle and SQL Server DataServers. I had a look at also implementing this for the OpenEdge side (using ado.Net I think) where it also made a substantial difference. The only reason I did not continue on this path was the deployment issue, the database would need to have a sql port open (security concern) and the clients would need to have an odbc connection - both which current installations did not yet have.

Continue reading...
 
Status
Not open for further replies.
Back
Top