[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Anyone using MS SQL dataserver with OpenEdge 11.7?

  • Thread starter Thread starter Mukesh Singh
  • Start date Start date
Status
Not open for further replies.
M

Mukesh Singh

Guest
Hi Lars, We have made performance improvement changes in 11.7.3 to evaluate single-shot query on server that may result in significant performance benefit for single shot query. As part of this feature changes is made in dataserver compiler layer and run-time code generation layer, and for that we generate WHERE clause predicates at compiler layer with owner name. It will works fine with -nojoinbyqldb or using QUERY-TUNING(NO-JOIN-BY-SQLDB) as it will disable this feature and will make join evaluation at client side, so this issue won’t be observed as owner name generation will be handled at run-time layer and owner name will be enclosed within quotes so it works fine. You can ask TSE to log a bug for this issue. Thanks, Mukesh

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