Hi all,
I have a firebird server (FB 2.1, Superserver) on windows OS with database
file store on an external harddisk. There are about 5 users accessing this
database.
I never try or have NAS, is it possible just to move firebird db file from
external hardisk to NAS?
If this is
Hi,Thanks for you reply.
If I understand correctly, WD Cloud come with password to access private folder.
So, I am planing to install FB server where NAS attached and set private folder
in NAS, then map this folder as a network drive.
Other users, don't have direct access to this private
Hi guys,I tried to installed Zebedee on CentOS 6.3, but failed because of
missing library. The library was related with OpenSSL.
I have search in the net, Zebedee using very old library that no longer
supported on CentOs 6.3, the only way to install it on CentOS is to build from
its source
Wow, that's great.Please kindly send to my email, I need an 64 bit and thanks
you so much.
Regards,
Anto
Works great !!Thanks again for your help.
Regards,
Anto
Hi,Thanks for your suggestion. Already look STunel, but since I am more
familiar with zebedee, and now it works on Linux, I will stick with it.
Regards,
Anto
Hi, thanks for your info.
This is exactly what I am looking for. I need to encrypt some field and use
firebird only to store, no index needed.
May I know the program you use to encrypt your data?
Thanks regards,
Anto
Yes you were right.
Just found the solution, just comment RemoteBindAddress in firebird.conf &
restart firebird service and it works.
By the way, for a small database, firebird server performance on Raspberry Pi2
is not bad at all.
With my microSD (read speed about 20MB/s), it took about 2
Yes you were right.
Just found the solution, just comment RemoteBindAddress in firebird.conf &
restart firebird service and it works.
By the way, for a small database, firebird server performance on Raspberry Pi2
is not bad at all.
With my microSD (read speed about 20MB/s), it took about 2
Hi guys,
Have any of you success to install Firebird on Raspberry and able to connect to
its database remotely via Windows machine?
I have these settings on Raspberry Pi:
- OS : Raspbian Jessie
- Firebird 2.5 SuperServer
- static ip address on Pi : 192.168.1.50
With Isql on the raspbian's
Thanks for your reply,
Unfortunally, there no inetd command on Raspbian and I don't know compatible
command in it.
Regards,
Agus
Hi guys,
Since Zebedee for Java is a beta ver. and not maintain again, are there any
alternative to this program?
Thanks in advance.
Regards,
Anto
I need a Java jar file, so it can run on Linux or Windows.
Hi guys,
I am building a new project using FB 3.0 - SS, I have a few questions :
1) Since FB 3.0 support WireCompression, should I still use Zebedee?
2) Is that possible to hide stored procedure/trigger codes in FB 3.0 ? Usually
I used this statement :
UPDATE RDB$TRIGGERS a set
[#CORE-5210] Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work - Firebird
RDBMS Issue Tracker http://tracker.firebirdsql.org/browse/CORE-5210
http://tracker.firebirdsql.org/browse/CORE-5210
[#CORE-5210] Firebird 3.0 + fbclient 3.0 - POST_EVEN...
In my case, POST_EVENT still not working correctly.
Anto
Dear all,
Sorry, I have miscalculated the setting in DefaultDbCachePages, it was set more
than available RAM on my Computer, no wonder it crashed.
Now, everything is OK, tested on SS FB 3.0 in Win64.
Thanks for your helps,
Best regards,
Anto.
Dear Mark,
Thanks for you info, solved the problem.
Regards,
Anto.
Hi guys,
Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in Win64
is only 2 GB? Calculated from max DefaultDbCachePages (131072) x max Page Size
(16384) = 2 GB.
Setting DefaultDbCachePages more than allowed caused a crashed.
If this true, how to optimaze free RAM for
Hi guys,
I have a table with existing data & got a problem to add field that must have a
value -> alter table Tbl1 add Fld1 int not null.
If table doesn't have data, it is OK, but Firebird refused if table already
have data. Any suggestion how to solve this problem?
Thanks & regards,
Anto
Hi all,
Just migrating from SC FB 2.5.2 to SS FB 3.0 (both in Win x64), i found a few
problems :
1) Query that runs about 2-3 secs in SC FB 2.5.2, runs minutes in SS FB 3.0
Query is something like this :
Select a.col1,b.col1 from tbl1 a, tbl2 b where a.id = b.id and b.id in (select
c.id from
From SC FB 2.5.2 to SS FB 3.0, all on Win64, I can confirm 2 things :
1) Post Event on SS 3.0, sometimes works, sometime not. I have an app that use
post_event. Sometime I have to restart this app a few times to make post_event
works.
2) Stored Procedure/Query
I have noticed that SP/Query that
Hi,
This is the Query plan from SS FB 3.0
PLAN (GET_STCK NATURAL)
and here is the Query plan from SC FB 2.5.2
PLAN (G_T3 NATURAL)(M_TT INDEX (RDB$PRIMARY2))(A INDEX (IDX_M_GD3))(A INDEX
(IDX_M_GD3))SORT (JOIN (B INDEX (TM_D), A INDEX (T2_T1), C INDEX
(RDB$PRIMARY25), D INDEX (RDB$PRIMARY21),
Hi,
About Db cache, found the problem. Now I could set Db Cache per database at 2
GB (16384 x 131072), try to set at 4GB (16384 x 262144), no error on gfix, but
it just crashed when tried to connect, no error message shown.
Regards,
Anto.
Hi,
Tested again with FB 2.5.1 & FB 2.5.5, apparently, this is not a problem from
FB 3.0, but it was already appeared since FB 2.5.
Same machine, database, query & engine, SC FB 2.5.1 & SC FB 2.5.2 runs a lot
faster than FB 2.5.5 & FB 3.0.
Regards,
Anton
Hi guys,
Just found that on a particular case, SS FB 3.0.1 is about 4x slower than SC FB
2.5.2.
Here is the query :
==
select a.id,b.nm from tbl1 a, tbl2 b
where a.id = b.id
and a.id in (select c.id from tbl3 c)
If the query change to this :
Hi all,
I have a strange result when running update operation.
I am using TIBSQL from Borland CBuilder 6, Firebird Super Clasic 2.5.2 (64bit)
on Windows 7 64 bit.
Here are the script from TIBSQL :
=
Update table1 set field1 = 'abc', field2 = 'abc', field3 = field3 + 1
Hi guys,
Anyone here able to connect to FB 3.01 with JDBC 2.x?
I have tried with jaybird-full-2.2.11 & have adding these lines to
firebird.conf
1) UserManager = Srp, Legacy_UserManager
2) AuthClient = Srp, Win_Sspi, Legacy_Auth
But no avail, always got error message
Hi all,
Thanks for all your help, at last, I manage to connect to FB 3.0 via JDBC.
In case someone need to know how, this is steps required :
Legacy Authentication
http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-legacyauth.html
Hi all,
Is it possible to insert image into FB database directly via sql stament using
isql or flamerobin?
Thanks & regards,
Anto
Hi all,
During project development/testing or database maintenance, such as
backup/restore, mostly, there is only 1 connection to FB Server.
I have 6 core processors and during those process, cpu's utilization is about
16%. I knew, this is because there is only 1 connection to FB server, 2
Hello all,
As you know, on a single connection, Firebird's cpu utilization calculate by
100% / no of cores.
On my 6 cores cpus, its only utilized 100% / 6 = 16%.
During database maintenance & testing (backup, restore, testing, etc) ,
sometimes, i feel it was to slow.
I want to change cpu
Hello all,
As you know, on a single connection, Firebird's cpu utilization calculate by
100% / no of cores.
On my 6 cores cpus, its only utilized 100% / 6 = 16%.
During database maintenance & testing (backup, restore, testing, etc) ,
sometimes, i feel it was to slow.
I want to change cpu
Not related to queries, like I said before, it was for maintenance such as
backup / restore, delete, insert,etc.
From those operations, I noticed that Firebird 3.0 SS didn't use 100% cpu
utilization. For queries, i guest, the behavior will be same
If cpu utilization can be set, perhaps, all
Thanks for your clarification.
I was planning to upgrade my cpu with a used Xeon 2683 V3 (price on my country
is about the same with I7 6700K), but it has 14 cores & 35MB L3 cache.
So, I guess, a single connection in Firebird 3.0 will running poorly on Xeon
2683 V3, it will only utilized about
Hi all,
I am considering to upgrade my development cpu.
Between Ryzen & KL, although Ryzen is very good at multi threaded processing, I
guest, for Firebird, KL will be faster.
For development, mostly I used only single connection to FB, and since FB
distributed workload among cores, for a
Hi guys,
I am using FB 3.02 in Superserver mode.
During my development - only single connection to FB Server, I do a lots of
query. Each query took about 25-30 secs to complete, but CPU Utilization only
used at around 16% on my six cores computer.
On Ryzen 7 with 16 threads, I believe CPU
Hi,
Thanks for the tips. I will test again with your tip.
Those Query plan created automaticaly by Firebird.
But on FB 3.0.2, it was a bad plan that hurt performance a lot.
I want to moved to FB 3, but because of this, i am hesited.
Anto.
Hello guys,
I have this query :
SELECT a.BB, a.PLUS, a.MINUS, a.ENDBLNC, vw.UNT,vw.SLS_PRC_DS,vw.SLS_PRC_DT
from GET_STCK_MUT_PSG_CNT('09-18-17','09-18-17','All') a, M_FNGD_VW vw
where a.ID = vw.FNGD_ID
and a.ENDBLNC >= 0
order by vw.NM,vw.cl, vw.SZ_CD, vw.ASST_CD
On SuperClasic FB 2.52 on
Hello guys,
I have this Query
select c.ID , e.CD, f.CD, sum(a.STCK_CLC) as qty, e.UNT, d.ID, g.ID
from t_in_ot2 a, t_in_ot1 b, M_FNGD c, M_ART d, M_Sz e, M_ASST f, M_CLR g,
m_trs_typ h, G_TMP j
where d.ID = c.ART_ID
and g.ID = c.CLR_ID
and e.ID = c.SZ_ID
and f.ID = c.ASST_ID
and c.id =
Hello guys,
Just want to inform that FB 2.5.2, mostly have a better query plan than FB
3.0.2.
I have 2 PCs, A & B, both have Win 7 x64 and almost identical hardware.
On PC A, FB SC 2.5.2 installed, on PC B, SS 3.0.2 installed.
Query on PC A, that process about 150K records, retrieved about 19
Hello all,
I ran an update query on a database with a computer and a notebook.
CPU's computer is Phenom 1075T, while notebook is i5 2557M.
Query is very simple, something like : update tbl set ln = 9;
Firebird on Computer is SS 3.0.3, on notebook SS 3.0.2, both runs on Windows
x64, both
I don't think so.
When notebook speed to limit only 0.8GHz, process drop significantly.
Update query, something like : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.
I think CPU processing was used to calculate search for index.
I don't think so.
When notebook speed limit to only 0.8GHz, process drop significantly.
Update query, something like : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.
I think CPU processing was used to search for index.
I don't think so.
When notebook speed to limit only 0.8GHz, process drop significantly.
Update query, something like : update tbl, set ln=-999 where id = 1
Id is primary key in tbl.
I think CPU processing was used to calculate search for index.
I don't think so.
When CPU speed on notebook limit to 0.8GHz process drop significantly.
Yes it was update only 1 record at the time.
But total records need to be updated is about 19.500.000.
So I made a small program that update 1.000.000 record and that's how the
calculation came out.
If only updated 1000 records at the time, the desktop runs faster but when it
reach 1.000.000
Hi guys,
For example, I have these characters : Í*B#È4jÎ
I can copy paste that characters with flamerobin into Firebird table, but how
to insert it via code?
Thanks & regards,
Anto
Hi guys,
I am running SS FB 3.0.4 x64 in Windows 10 x64 with 16GB RAM.
Database properties
ODS Version 12
Page size 16384
Pages 437728
Size on disk 6.68GB
Page buffers 10240
Read only false
Settings
Dialect 3
Default character set NONE
Sweep interval 2
Forced
Thanks for your reply.
Unfortunately, RAMMap don't work in Windows 10.
Hi guys,
I compared firebird 3 SS performance in windows 10 pro 64 vs Linux mint 19.1
cinnamon 64 bit.
Both OS use the same database configurations & almost the same speed ssd.
Windows use a bit faster ssd.
On windows 10, I have turn off everything than can be turn off, such as bloat
ware,
Hello,
Thanks for the replied. I have downloaded new RAMMap ver 1.52 and it work on
Windows 10.
On Process tab of RAMMap, firebird.exe took 2,183,484K.
On File details tab, database file took 2,603,168K.
Does it means, FileCached worked? It if worked, how come, the disk kept
spinning when
Thanks for your info.
Downloaded ver 1.52, now it worked.
On Process tab of RAMMap, firebird.exe took 2,183,484K.
On File details tab, database file took 2,603,168K.
Don't know, if this means file cached work or not.
If file cached worked, then there is something else that make Firebird runs
Hello,
I have tried to enable LargeSystemCache on Windows 10, no effect.
With or without LargeSystemCache, the second query run on Windows 10 was about
33% faster than the first run, I guest File Cached did work although still saw
disk activity.
But even the second query runs, it was still
Thanks for the info.
I downloaded ver 1.52, now it works.
As I expected, on Windows 10, File System Cached doesn't work.
Discussion continue here, as it is a related topic
https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/134237
Hi guys,
I have FB 3.04 SS in windows 10.
I have a database with these setting on database.conf
my_dba = C:\Dba\db.fdb
{
FileSystemCacheThreshold = 393216
LockMemSize = 16M
LockHashSlots = 30011
TempCacheLimit = 2048M
TempBlockSize = 2M
FileSystemCacheSize = 50
}
Hi guys,
I have installed FB 3.04 on Windows 7 64 bit.
On Firebird configuration file, have set Temporary Directory to e:\;d:\temp.
I got an error :
I/O error during "WriteFile" operation for file "e:\fb_table_u9" Error while
trying to write to file. There is enough space on the disk.
I
57 matches
Mail list logo