[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: DataServer Questions (How widely used? Linux options?)

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

dbeavon

Guest
Thanks Gus. "Brokerless" is probably a less confusing term. The DataServer documentation that I was reading used the term "self-service", but I assume that is talking about the same thing. Basically the ABL client process will load the ODBC client driver into memory and will then interact with SQL Server directly from the ABL code without having to go thru any middle-man. So far I have been very pleased with DataServer for SQL. I am fairly new to it. But from what I've seen, the types of batched (read-only) queries that are sent to the database seem even more efficient than what you can manage to get out of a "client-server" connection to the OpenEdge RDBMS. On the other hand, updating the SQL database seems a bit on the slow side (I've only been able to get up to 200-300 records per second ). I haven't tried using custom SQL stored procedures yet, but I hear that is even faster yet. Any thoughts on the possibility of a "brokerless" connection to SQL from Linux?

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