A project is looking at moving from using Oracle to Postgres. Direct Oracle Access (DOA) components are used to talk directly to Oracle server now.

-
A project is looking at moving from using Oracle to Postgres. Direct Oracle Access (DOA) components are used to talk directly to Oracle server now.

Switching to Postgres, there's a question whether FireDAC's Postgres components are good, or if it's better to use some Pg-specific components for even better performance?

(I see lots of comments that FireDAC's various DB connections tend to be quite fast, but I have no experience with them.)

Comments

  1. David SchwartzApril 26, 2018 at 1:42 PM

    What about encrypted connections? I'm seeing where libpq.dll has an option to support SSL on their TCP/IP channel.

    But I don't see where any of the component libraries that offer direct DB connectivity mention secure data channels or encryption.

    ReplyDelete
  2. David SchwartzApril 29, 2018 at 12:31 PM

    A. Bouchez I was just looking over your benchmark data. This is quite an impressive job you did! I saw a mention that this benchmark code is available to run ourselves, but where can it be found? Also, are the results available in an XLS spreadsheet format (or CSV)? It would be good to be able to look at the data in different ways.

    ReplyDelete
  3. A. BouchezApril 30, 2018 at 5:07 AM

    David Schwartz This is https://github.com/synopse/mORMot/tree/master/SQLite3/Samples/15%20-%20External%20DB%20performance

    ReplyDelete

Post a Comment