On 01/11/17 16:19, Vlad Khorsun wrote: > 11.01.2017 15:09, Alex Peshkoff wrote: >> >>>> Could you try fb2.5 (as i did) ? >>> Will do. >>> >> On 2.5 I see approx 50% slowdown when GC is in progress. Same slowdown >> is present when 'delete from test' is executed. > Slowdown of what operation ?
I've read in 5419: > This will cause the database server to become unstable and hang for > minutes at a time(1-5 minutes), where no new connections is made and > no other queries get processed. So I've started the following script: for i in `seq 10000`; do echo step $i; echo 'set stats on; select current_time from rdb$database;'|./isql todel.fdb ; sleep 1; done CURRENT_TIME ============= 16:18:36.0000 Current memory = 1146128 Delta memory = 101120 Max memory = 1154216 Elapsed time= 0.02 sec <<<<< this time Cpu = 0.00 sec Buffers = 75 Reads = 16 Writes = 0 Fetches = 282 >> Rather hard to say for sure cause execution time of test >> connection varies from 0.01 sec to 0.02 sec for 2.5, not more. For >> master it seems to be almost always 0.01. > What is done in that test connection ? Could you try to create table > and insert record into it ? Will do. ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
