icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz
On 25.01.20 18:43, Slavomir Skopalik skopa...@elektlabs.cz
[firebird-support] wrote:
Hi all,
I have a dump file for this situations (160MB):
RESTOREFB3 Sat Jan 25 18:33:19 2020
Shutting down the server
Hi all,
I have a dump file for this situations (160MB):
RESTOREFB3 Sat Jan 25 18:33:19 2020
Shutting down the server with 11 active connection(s) to 1
database(s), 0 active service(s)
RESTOREFB3 Sat Jan 25 18:33:29 2020
JProvider::shutdown:
Firebird shutdown is still in pr
For exact numbers you have to use exact numeric types.
Double is float point type with all advantages and disadvantages.
Look here
https://en.wikipedia.org/wiki/Double-precision_floating-point_format
Just for fun, try this:
1e20 + 1 + 1 - 1e20 + 1
Slavek
Ing. Slavomir Skopalik
Executive He
20.8.2018 23:28, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 20.08.2018 22:07, Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]
> wrote:
>> Any other solution that will work?
> It depends on what kind of cluster and for what purpose is needed. Simple
Hi all,
customers asking for clustering solution.
I found this one:
https://www.evidian.com/products/high-availability-software-for-application-clustering/firebird-high-availability-synchronous-replication-failover/
Do somebody experience with that, any reason to do not used?
Any other solutio
Hi,
we are using combination of bat and SQL.
In bat file we are generating SQL and vice versa.
Some example:
@SET sql=s1.sql
@ECHO SET TERM ^^; >%sql%
@ECHO EXECUTE BLOCK AS>>%sql%
@ECHO DECLARE VARIABLE s VARCHAR(1000);>>%sql%
@ECHO BEGIN>>%sql%
@ECHO s = 'CREATE USER %3 PASSWORD ''%4'';';>
Hi,
I test general impact of compression and I found that for FB 2.5 and FB3
is critical to take another DB page from cache.
Also any cache miss significantly reduce performance.
With current compression and if we have a number lest say 0x3337 stored
in three columns.
BIGINT it will be unc
Hi,
advantage of SmallInt vs INT vs BIGINT is data density (keep record
shortest as possible).
If you have one column, it is irrelevant, if you have ten columns, you
will see speed improvement.
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data
And did you update client library as well?
please run this sql in isql and post here result:
select * from Mon$Attachments
and for sure
select rdb$get_context('SYSTEM','ENGINE_VERSION') from rdb$database
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation
Hi,
I never used embedded, but seems to be, that you using wrong dll name.
Try to read this topic:
https://www.codeproject.com/Articles/9445/Embedded-Firebird-Full-Featured-Embedded-Database
http://stackoverflow.com/questions/26179554/unable-to-access-embedded-firebird-database-server-with-net-
Yes, look here:
public static void CreateDatabase(string connectionString, int pageSize
= 4096, bool forcedWrites = true, bool overwrite = false)
{
CreateDatabaseImpl(connectionString, pageSize, forcedWrites, overwrite);
} As connection string you can use file name. Look for example here:
http
Try 3.0.2, probably another situation related to
http://tracker.firebirdsql.org/browse/CORE-5392
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
--
It is depend on language and frame work that you using.
In delphi:
if not result.Prepared then
result.Prepare;
// Check params consitency
if Length(Params)>0 then begin
if result.Params.Count<>Length(Params) then
Slavek
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.
Hi,
Dimitri is right.
If you just prepare statement (ANYONE) server will return record
structure including names and data types.
Also, you task is not problem to solve without prepare.
Just at first iteration read the names and put to output before data.
Slavek
Ing. Slavomir Skopalik
Executi
Hi,
look at my example that I'm using for preparing two DB fou join into one
big.
My be it will help you.
-- Prepare data table for replication
-- Ensure that data in both databases are unique
-- No overlap during replication will occur
CREATE OR ALTER PROCEDURE Repl$SynchronizeDataTable(
Ma
We have another tables that contain definition of each relation and each
field.
Data for this tables are automatically generated from case tool like this:
EXECUTE BLOCK AS BEGIN
--definition fields for entity: USERFUNCTIONS
IF (EXISTS(SELECT 1 FROM rdb$relations where rdb$relation_name =
'USERF
Hi Roland,
in some cases we did this to log all transaction starts commits (see
script below).
Set GenMonTransactions to value less 1 will activate log function.
You can simply to change to log transaction commits or rollbacks as well.
And in application you can easy log transaction id tha
Hi Helen,
sorry for question too specific to ibReplicator.
I still looking for replication SW, because all SW mentioned here
(ibReplicator, symmetricds, CopyCat) has some issues.
Or experience with writing it by self from someone who already did it.
Thank you for understanding.
Slavek
Ing. Sl
Thank you,
I was try and I found few problems.
1. I failed to set up replication on Db Event (in manual is mentioned).
Any idea how to do with IBreplicator?
2. I failed to transfer all table operation.
Only last values are transfered.
This fail, if is circular link between records like
record A h
te is older
> regards,Karol Bieniaszewski
>
>
> Pozdrawiam
>
> ---- Oryginalna wiadomość
> Od: "Slavomir Skopalik skopa...@elektlabs.cz [firebird-support]"
>
> Data: 26.11.2015 12:46 (GMT+01:00)
> Do: firebird-support@yahoogroups.
if you have a table called PARTS,
> create SYNC_PARTS and each time there is a change to PARTS you add a
> record. You could then send your updates to HO via a scheduled update or
> even within the same transaction if your network access allows for that.
>
> Alan J Davies
> Aldis
Hi all,
we are preparing new project with bidirectional replication.
Customer idea is to have master database in head quoter
and slave databases on production plant (to solve network performance
and availability issues).
Witch replication SW you can recommend for this bidirectional replication?
Hi All,
we are looking for new modeling tool that will replace our unsupported
CaseStudio2.
I was made quick look at
http://www.modelsphere.org/
and
http://www.toad-data-modeler.com/enu/default.aspx
but I not sure that is right choice.
We needs:
-model diagram with sub models
-user scripting
23 matches
Mail list logo