2019. 01. 21. 17:41 keltezéssel, Dmitry Yemanov írta:
This is a single-threaded test, isn't it?
2.5 - 2:59 - 65.65 MB
3.0 - 3:27 - 68.95 MB
4.0 - 3:37 - 68.95 MB
The results are more or less expected in this case (it doesn't mean
they're desirable but this is a different story).
Same script into 5 databases concurrently:
2.5 - 10:55
3.0 - 8:11
4.0 - 8:41
Same script with numbered(1..5) table names into one database concurrently:
2.5 - 10:51 - 336.72 MB
3.0 - 8:09 - 329.79 MB
4.0 - From the 5 ISQL 2 fail constantly. Tried 5 times and 2 fail always
from 5:
Statement failed, SQLSTATE = 40001
update conflicts with concurrent update
-concurrent transaction number is 7
After line 0 in file R:\SCRIPT\TRADE_DATA_1.sql
After applied "ReadConsistency = 0" into firebird.conf:
4.0 - 8:45 - 329.79 MB
Gabor
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
