Понедельник, 13 июля 2020, 12:41 +03:00 от Martin Kersten <martin.kersten@cwi.nl>:
 

Hi

Could you try out this version https://github.com/bolner/MonetDB-PHP-Deux
and report on your findings.

regards, Martin

On 13/07/2020 08:52, - - wrote:

> hi Martin,
>   monetdb version: 11.37.7-20200529
>   sql: generic insert — INSERT INTO table(id,v1,v2,v3,v4) VALUES (…);
>   test: same environment for both servers: vmbox 8gb, 4 cores, only one server is running on tests, no load of the host server
>   php 7.4.5,  SQLAnyhwere pdo extension;  php-monetdb-1.0-1.el8.noarch.rpm
>   script: same for both tests except connection, measured only loop execution,   the script uses «random» functions to
>   generate  data for insert
> function str_random($length = 3200)
> {
>     $pool = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
>     return substr(str_shuffle(str_repeat($pool, $length)), 0, $length);
> }
>   the execution time ratio for all tests was almost the same. each test was done on «clean» server.
>   one of the test:
>   monetdb:  Work: 796.90835905075 seconds
>   SQLA:      Work: 382.80270600319 seconds
>   /alex
>
> Понедельник, 13 июля 2020, 8:44 +03:00 от Martin Kersten <martin@monetdb.org>:
> Hi <who am i talking to?>
>
> There can be many reasons. Ranging from version used, SQL difference, test running, en PHP? API.
> Based on the information provided this can not be judged.
>
> regards, Martin
>
> On 13/07/2020 02:13, - - wrote:
> > I have run the series of INSERT tests in PHP for monetdb and SAP SQLAnywhere.  The tests show: performance of the monetdb on INSERT operations is almost twice slower against SQLA with the equal conditions (DDL, index, data, autocommit, 10K records),
> > monetdb is in in-memory mode . What can be a reason?
> > p.s. It is not benchmark, I just used the SQLA test server already running.
> > --
> > - -
> >
> > _______________________________________________
> > users-list mailing list
> > users-list@monetdb.org </compose?To=users%2dlist@monetdb.org>
> > https://www.monetdb.org/mailman/listinfo/users-list
> >
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org </compose?To=users%2dlist@monetdb.org>
> https://www.monetdb.org/mailman/listinfo/users-list
>
> --
> - -
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list