13 Jul
2020
13 Jul
'20
6:12 p.m.
https://github.com/bolner/MonetDB-PHP-Deux
the results are in the same ratio.
any suggestions?
monetdb
Work: 793.54999995232 seconds
Work: 813.93353414536 seconds
Work: 798.28180193901 seconds
SQLA
Work: 381.90039515495 seconds
Work: 380.11742515733 seconds
Work: 384.53782300789 seconds
>Понедельник, 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
--
- -