[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQLite for temp tables

[Thomas Mercer-Hursh]

I know that some people install appservers on separate boxes from the database, in part because it allows using cheaper boxes for all of the components ... but when I have asked people whose opinion I trusted in the past, there are obvious reasons not to do it. But, even if one does do it, one would think that one would work very hard to have a very high speed link between the DB box and the appserver box(es), much higher performance than going to the clients. To be sure, there can be an issue of currency even with TTs ... that's the whole reason for the work one goes to for updates when the record is not locked during modification ... but it seems to me externalizing magnifies that risk greatly.

Continue reading...