Hello! 18.04.2017, 22:22, "Dimitry Sibiryakov" : I want to push data to another database as fast as possible, I want to have 5 connections walk the list of tables and read the rows and push them to the target DB. With current Firebird architecture you won't get better performance from 5 connectio
Alpha 1, 3.0 Beta 1, 3.0.0
Reporter: kdv
I ask to extend GSTAT output with the information, already provided by
InterBase XE gstat.
These options are:
for tables:
now
Average record length: 67.06, total records: 31
nice to implement
Average record length: 67.06, total records
Affects Versions: 2.5.1
Reporter: kdv
Priority: Minor
table RDB$TYPES have duplicate records for some rdb$character_set_name.
Duplicates can be found by query
select rdb$field_name, rdb$type_name, count(rdb$type_name)
from rdb$types
group by rdb$field_name, rdb$type_name
Components: Charsets/Collation
Affects Versions: 2.5.1
Environment: Firebird 2.5.1.26351 32bit, Windows 7 64bit Ultimate.
Reporter: kdv
Priority: Minor
Alterting char/varchar columns to lower size produces error
New size specified for column fff
Reporter: kdv
Priority: Minor
Interesting, but gbak have only option -use_all_space for restore, but does not
have reverse option, to turn database flag no_reserve off.
gfix, instead, have -use full/reserve.
Thus, if I have backup, I can't turn no_reserve off.
I ne
, 2.1.5, 2.0.7, 2.5.1, 2.1.4, 2.5.0, 2.0.6, 2.1.3,
2.1.2, 2.0.5, 2.1.1, 2.1.0
Reporter: kdv
Currently ability to create database without path is near to security breach.
Because it allows user to create database "somewhere" (and then user can fill
it with data and consume
A.
--
Key: CORE-4169
URL: http://tracker.firebirdsql.org/browse/CORE-4169
Project: Firebird Core
Issue Type: New Feature
Reporter: kdv
--
This message is automatically generated by JIRA.
-
If you think it was sent
Components: Engine
Affects Versions: 3.0 Alpha 1
Reporter: kdv
I ask in addition to existing DefaultDbCachePages add new
firebird.conf/database.conf parameter
DefaultDBCacheSize which can be specified in kilobytes, megabytes or gigabytes
of memory directly.
For example
Reporter: kdv
Grouping and sorting on expression produces additional SORT in plan.
Example.
When we group and sort on non-indexed field
select first_name, max(first_name)
from employee
group by 1
order by 1
we see PLAN SORT (EMPLOYEE NATURAL)
i.e only one sort used for grouping and
