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

  • Thread starter Thread starter dbeavon
  • Start date Start date
Status
Not open for further replies.
D

dbeavon

Guest
Thanks for sharing the links with us. I see you have a lot of experience running ABL on machines that are remote from the database (ie. not running in "shared memory"). One thing I noticed - and made me a bit envious - was your DataServer references. They talk about "server-side joins" which is something we don't even have yet for code that connects from ABL-to-OE. On the CVP forums I had tried to start a discussion about the possibility of allowing us access to a "DataServer for Progress SQL" (see community.progress.com/.../38825 ) It seems to me that this might be a path towards having server-side joins in our client-server code (ABL-to-OE). I'm assuming that the OpenEdge "DataServer for ODBC" could be made to work against Progress SQL, and I'm assuming that unlike regular client-server connectivity, the DataServer WOULD actually have server-side join functionality (just like the other DataServers). That would be awesome. It is a missed opportunity that Progress has never allowed us to connect to its SQL engine via DataServer. It would probably alleviate many performance problems which exist in their standard client-server connectivity... My understanding that for OE 12 they are trying to enhance their standard client-server it to allow server-side joins but it seems to me that this would already be available to us by now if they had ever given us "DataServer for ODBC". (Sorry to take things a bit off-course with a discussion about another type of performance concern)

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