From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=unavailable autolearn_force=no version=3.4.4 Path: eternal-september.org!reader01.eternal-september.org!feeder.eternal-september.org!news.uzoreto.com!aioe.org!.POSTED!not-for-mail From: "Dmitry A. Kazakov" Newsgroups: comp.lang.ada Subject: Re: Prepared_Statement :( Date: Tue, 27 Nov 2018 19:00:29 +0100 Organization: Aioe.org NNTP Server Message-ID: References: <37a5643e-02aa-48ab-b327-f76771d1f6e6@googlegroups.com> NNTP-Posting-Host: 6RgwMQWCXnjFVePlk7FG5g.user.gioia.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@aioe.org User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.3.1 Content-Language: en-US X-Notice: Filtered by postfilter v. 0.8.3 Xref: reader01.eternal-september.org comp.lang.ada:54914 Date: 2018-11-27T19:00:29+01:00 List-Id: On 2018-11-27 10:58, eduardsapotski@gmail.com wrote: > Dmitry, if I wanted to get a universal solution, I would never use Ada-language. I doubt universal solutions, especially if not in Ada! (:-)) > Over year ago I wrote trading terminal on Java. Uses JDBC and can easily change db-driver. Surely they cannot. RDBMS are way too different for this to work. Any "universal" solution must include a DB adapter to provide a reasonable application interface instead of the SQL mess (prepared or uncooked (:-)). > And application can be easily transferred to any server. > But what's the problem? > Year ago, trading was conducted on ten currency pairs, today more hundred pairs! > Java slows down and eats resources. > Server is running at the limit. > I am not so rich to buy Oracle SPARC M8. > Ada significantly reduces server load. Though Ada is far faster than Java it alone does not guarantee performance if the DB is the bottleneck. Ada allows very efficient custom persistent storage implementations when RDBMS fails. Here is a small comparison SQLite vs B-trees in Ada: http://ada-programming.blogspot.com/2014/09/ada-direct-io-b-tree-vs-sqlite.html > For this reason, I am not going to use anything other but PostgreSQL. > PostgreSQL very fast on insert operations. Even much faster than Oracle, other things being equal. I cannot tell if PostgreSQL is better than Oracle or MySQL or whatever. One should really benchmark them for the specific case to know. What I know is that the difference cannot be any dramatic. If one of them stops working all others probably will, and conversely. So if you have a real DB problem you possibly must say goodbye to all relational SQL-based DBs and look for a better custom algorithmic solution. -- Regards, Dmitry A. Kazakov http://www.dmitry-kazakov.de