Re: [firebird-support] Problem with linked table
Hi Dimitri, Firebirds server is installed on server and i can connect through OBDC from all workstations. The problem is only with the linked table on microsoft access DB. I create a Db access 2007 and i put it in a shared folder. All PCs have a mapped network drive (Z) to access this database. If i link tables from a pc "1", i can't read data from pc "2". But if i open the shared DB from pc "2", delete linked table and i re-link tables from pc "2", i can read data from pc "2" but i can't read data from pc "1". The error is the same: "connection failed" Do you need more information? Thank you in advance Adriano
Re: [firebird-support] Restore performance (gbak service_mgr) whilst activating indices
> Hello Group, > > Sorry if this double posts, I received an error when Sending. > > I was provided with a largish (~27GB) Firebird 2.5 backup file (gbak) > yesterday. I have been restoring this on Windows 2012R2 running 2.5.6 Classic > using gbak with the -service_mgr switch. This particular VM only has a single > CPU core but it is connected to the SAN and isn't doing anything else. I am > remote desktop'd into the machine. > > I have been tracking the restore through several mechanisms: > * -v switch of gbak > * How large the file is on disk > * CPU utilisation (Resource Monitor) > * Disk I/O (Resource Monitor) > > The first 40GB or so of the restored FDB took about an hour or so. The I/O for > fb_inet_server.exe was consistently in the 30MB/s range (usually about 10 read > from the fbk and 20 write to the fdb file) > The next 10 GB took 10 hours. Now obviously when it gets to "activating and > creating deferred index xyz" it slows down, but I cannot see where the > bottleneck is. I have seen extended periods of about 1MB/s reads corresponding > with 5% CPU utilisation whilst activating some of those indices. I copied an > unrelated 20GB file in the same folder and it happily copied at 50MB/s so > there > is definitely capacity that isn't being used. > > I can see that when it activates indices on larger tables it is creating temp > files and these are at least being written to at 8+ MB/s. > > Although I get that activating the indices is going to be slower than > restoring > the data, I was expecting to see it either CPU and/or disk bound at any moment > in time. (Plenty of headroom for memory and network utilisation is very low). The restore process is bound to a single physical core. I've seen something similar in the past, where basically no resource (CPU, disk I/O - throughput + IOPS) being exhausted, thus not bound to available hardware. Do you have an Antivirus solution running affecting the restored Firebird database and/or temporary created files during restore? You may also vote for: http://tracker.firebirdsql.org/browse/CORE-2992 -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Restore performance (gbak service_mgr) whilst activating indices
Hello Group, Sorry if this double posts, I received an error when Sending. I was provided with a largish (~27GB) Firebird 2.5 backup file (gbak) yesterday. I have been restoring this on Windows 2012R2 running 2.5.6 Classic using gbak with the -service_mgr switch. This particular VM only has a single CPU core but it is connected to the SAN and isn't doing anything else. I am remote desktop'd into the machine. I have been tracking the restore through several mechanisms: * -v switch of gbak * How large the file is on disk * CPU utilisation (Resource Monitor) * Disk I/O (Resource Monitor) The first 40GB or so of the restored FDB took about an hour or so. The I/O for fb_inet_server.exe was consistently in the 30MB/s range (usually about 10 read from the fbk and 20 write to the fdb file) The next 10 GB took 10 hours. Now obviously when it gets to "activating and creating deferred index xyz" it slows down, but I cannot see where the bottleneck is. I have seen extended periods of about 1MB/s reads corresponding with 5% CPU utilisation whilst activating some of those indices. I copied an unrelated 20GB file in the same folder and it happily copied at 50MB/s so there is definitely capacity that isn't being used. I can see that when it activates indices on larger tables it is creating temp files and these are at least being written to at 8+ MB/s. Although I get that activating the indices is going to be slower than restoring the data, I was expecting to see it either CPU and/or disk bound at any moment in time. (Plenty of headroom for memory and network utilisation is very low). Any suggestions on what I can look for or is this an expected characteristic/limitation? Thanks in advance Adam
Re: [firebird-support] FreeAdhocUDF and Firebird 3 not working
I am thinking FreeAdhocUDF is a dead project. It has not been updated for many years. The main thing though is that these UDFs work ok in Firebird 2.5. I have also developed a UDF (DLL) in Delphi, and that does not work either. It used to in 2.5 (still does). I thought it better to mention the FreeAdhocUDF issue otherwise it would be my fault that my own UDF does not work! There is obviously something different about V3 that is stopping some UDFs from working. In my own limited experience, it is stopping ALL UDFs from working. And this is not a trivial problem. I have spent days trying to remove UDFs from my existing 2.5 version databases, and it is not an easy job.
Re: [firebird-support] Problem with linked table
07.09.2017 19:48, Adriano Novelli adrianonove...@yahoo.it [firebird-support] wrote: > What should I do to read data from the tables linked from every pc and not > just that with > which I linked the tables? Learn more about client-server technologies. You must install Firebird server on server and connect to it from all workstations. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Problem with linked table
Hi, i have a problem with linked table on microsoft access 2007. In my db access, i link some table from FirebirdsSql (through ODBC) and i put it on a shared folder (accessible from other corporate PCs). The problem is that when I try to read the data from the linked tables, if I use the pc with which I linked the tables, everything works. If I use the same software from another pc instead I have an error "connection failed". What should I do to read data from the tables linked from every pc and not just that with which I linked the tables? Can you help? Best regards Adriano
[firebird-support] Collation with Numeric-Sort and index
Hi all,
Sorry for being late to the party, finally got some time get my hands on moving
from FB2.5 to FB3.
I'm looking at creating collations in order to get WHERE and ORDER BY working
as my needs, preferably also handling of numeric stored as text sorted in
numeric order.
Still haven't decided yet if I should go for ISO8859_1 or for UTF8 though,
weighing pros and cons regarding features and impact of bytes.
Living in Sweden I think most of you know that I have to deal with åäö.
However, I have found some quirks that currently prevent my progress.
First I have downloaded the snapshot for FB 3.0.3 for Windows
(Firebird-3.0.3.32802-0_x64).
In order to get UNICODE collation with Swedish to work I went to
http://site.icu-project.org/download and downloaded icu4c-52_1-Win64-msvc10.zip
from where I got the icu*52.dll's and extracted them to FB3. (After I first had
deleted all icu*.* files in FB3).
No changes done in intl\fbintl.conf or anything else, is it really that simple?
Then I created a database, created some collations and a table with some data:
SET NAMES UTF8;
SET SQL DIALECT 3;
CREATE DATABASE 'C:\Data\Test\Collation_CI.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8;
SHOW VERSION;
ISQL Version: WI-V3.0.3.32802 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.3.32802
Firebird 3.0"
on disk structure version 12.0
CREATE COLLATION UTF_SV_CI
FOR UTF8
FROM UNICODE
CASE INSENSITIVE
'LOCALE=sv_SE';
CREATE COLLATION UTF_SV_CI_NUM
FOR UTF8
FROM UNICODE
CASE INSENSITIVE
'LOCALE=sv_SE;NUMERIC-SORT=1';
CREATE COLLATION ISO_SV_CI
FOR ISO8859_1
FROM SV_SV
CASE INSENSITIVE;
COMMIT;
CREATE TABLE TABLE_T (
FIELD_UTF_SV_CI VARCHAR(5) CHARACTER SET UTF8 COLLATE UTF_SV_CI,
FIELD_UTF_SV_CI_NUM VARCHAR(5) CHARACTER SET UTF8 COLLATE
UTF_SV_CI_NUM,
FIELD_ISO_SV_CI VARCHAR(5) CHARACTER SET ISO8859_1 COLLATE ISO_SV_CI
);
COMMIT;
INSERT INTO TABLE_T VALUES ('1', '1', '1' );
INSERT INTO TABLE_T VALUES ('2', '2', '2' );
INSERT INTO TABLE_T VALUES ('10', '10', '10');
INSERT INTO TABLE_T VALUES ('20', '20', '20');
INSERT INTO TABLE_T VALUES ('a', 'a', 'a' );
INSERT INTO TABLE_T VALUES ('AA', 'AA', 'AA');
INSERT INTO TABLE_T VALUES ('aa', 'aa', 'aa');
INSERT INTO TABLE_T VALUES ('Aa', 'Aa', 'Aa');
INSERT INTO TABLE_T VALUES ('A', 'A', 'A' );
INSERT INTO TABLE_T VALUES ('b', 'b', 'b' );
INSERT INTO TABLE_T VALUES ('B', 'B', 'B' );
INSERT INTO TABLE_T VALUES ('o', 'o', 'o' );
INSERT INTO TABLE_T VALUES ('O', 'O', 'O' );
INSERT INTO TABLE_T VALUES ('x', 'x', 'x' );
INSERT INTO TABLE_T VALUES ('X', 'X', 'X' );
INSERT INTO TABLE_T VALUES ('å', 'å', 'å' );
INSERT INTO TABLE_T VALUES ('Å', 'Å', 'Å' );
INSERT INTO TABLE_T VALUES ('ä', 'ä', 'ä' );
INSERT INTO TABLE_T VALUES ('Ä', 'Ä', 'Ä' );
INSERT INTO TABLE_T VALUES ('ö', 'ö', 'ö' );
INSERT INTO TABLE_T VALUES ('Ö', 'Ö', 'Ö' );
COMMIT;
Now some tests.
SELECT FIELD_UTF_SV_CI
FROM TABLE_T
WHERE FIELD_UTF_SV_CI BETWEEN '' AND 'b'
ORDER BY 1;
FIELD_UTF_SV_CI
===
1
10
2
20
a
A
aa
Aa
AA
b
B
===
Result as expected
SELECT FIELD_UTF_SV_CI_NUM
FROM TABLE_T
WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b'
ORDER BY 1;
FIELD_UTF_SV_CI_NUM
===
1
2
10
20
a
A
aa
Aa
AA
b
B
===
Result as expected
SELECT FIELD_ISO_SV_CI
FROM TABLE_T
WHERE FIELD_ISO_SV_CI BETWEEN '' AND 'b'
ORDER BY 1;
FIELD_ISO_SV_CI
===
1
10
2
20
A
a
Ä
Å
Ö
ä
å
ö
AA
Aa
aa
B
b
===
Not the expected result.
Both wrong order and records that should not be there.
Let's add some index:
COMMIT;
CREATE INDEX IDX_UTF_SV_CI ON TABLE_T (FIELD_UTF_SV_CI);
CREATE INDEX IDX_UTF_SV_CI_NUM ON TABLE_T (FIELD_UTF_SV_CI_NUM);
CREATE INDEX IDX_ISO_SV_CI ON TABLE_T (FIELD_ISO_SV_CI);
COMMIT;
And repeat the queries from before:
SELECT FIELD_UTF_SV_CI
FROM TABLE_T
WHERE FIELD_UTF_SV_CI BETWEEN '' AND 'b'
ORDER BY 1;
FIELD_UTF_SV_CI
===
1
10
2
20
a
A
aa
Aa
AA
b
B
===
Result as expected
SELECT FIELD_UTF_SV_CI_NUM
FROM TABLE_T
WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b'
ORDER BY 1;
FIELD_UTF_SV_CI_NUM
===
1
2
10
20
a
A
aa
Aa
AA
b
===
Not the expected result.
Where did the 'B' go?
SELECT FIELD_ISO_SV_CI
FROM TABLE_T
WHERE FIELD_ISO_SV_CI BETWEEN '' AND 'b'
ORDER BY 1;
FIELD_ISO_SV_CI
===
1
10
2
20
a
A
å
Å
ä
Ä
ö
Ö
AA
aa
Aa
b
B
===
Not the expected result.
Both wrong order and records that should not be there.
Although the order differs slightly from the same query without index.
I have done the same tests with the release version of FB 3.0.2
(Firebird-3.0.2.32703-0_x64) as well as tested with icu 53 and 57 for them both
with the same result, no differences there.
Using the original icu files that comes w
[firebird-support] Problem with linked table
Hi, i have a problem with linked table on microsoft access 2007. In my db access, i link some table from FirebirdsSql (through ODBC) and i put it on a shared folder (accessible from other corporate PCs). The problem is that when I try to read the data from the linked tables, if I use the pc with which I linked the tables, everything works. If I use the same software from another pc instead I have an error "connection failed". What should I do to read data from the tables linked from every pc and not just that with which I linked the tables? Can you help? Best regardsAdriano
Re: [firebird-support] FreeAdhocUDF and Firebird 3 not working
Hi, > I have been using Firebird 2.5.7 64 bit on Windows 7 for sometime, also > using FreeAdhocUDF. I just installed Firebird 3.0.2.32703 64 bit and now > FreeAdhocUDF is no longer loading. > > I see that there is a support ticket in place for this exact bug, but so > far no resolution. This is a major problem as I will have to roll back > to 2.5 unless I find a work around. > > Has any one found a resolution for this problem? I mainly use the F_DVL > function to get around null values, so I guess I can use a case > statement (a lot of work though). It would be nice to get FreeAdhocUDF > working again, of course. Have you tried to contact the creators of FreeAdhocUDF? This is basically a third-party UDF library not being maintained by the Firebird project. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] What is currently available ...
Having be reliant on Interbase and then Firebird since the 90's I have a lot of client data stored which I can rely on being available. Early systems still use the windows based builder 6 code for some areas, but on the whole access is via web based interfaces. I've used PHP5 since before it's initial release, and I've many sites working stably and reliably under Apache or Nginx into Firebird. I have been maintaining ADOdb as much as I can and have a framework which is fairly up to date with PHP7.1 but many of my live sites are still running on older versions of the stack and framework. The problem is where to go next ... I'm running a couple of wordpress sites, but they need MySQL (MariaDB being used) and I have OSM services running which need a Postgresql and there is little chance of moving them onto Firebird so is it time to throw in the towel and move everything over to something that is getting more support? I had tikiwiki running with Firebird before forking that to a more flexible code base, but tiki as it is now has lost much of it's cross database support. TYPO3 looked like an option, but recent 'improvement' have lost the Firebird/Interbase port. Is it time to even ditch PHP and move to something a lot more stable? Just what is currently available as a web site stack on to of Firebird. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
