Yes, I needed it, thanks for your answer.
Regards,
Anto
Hi,
Thanks for your replied.
Tried to use execute STATEMENT 'COMMIT', raised and error
Explicit transaction control is not allowed
Hi guys,
I have a simple stored procedure to update data, like this :
SET TERM ^ ;
CREATE PROCEDURE REG
AS
BEGIN
UPDATE table a set a.field1 = '123';
exit;
END^
SET TERM ; ^
When I run that procedure on flamerobin with this command:
execute procedure Reg.
It runs ok
Dear all,
Thanks for your answers. As I know FAT32 is not limited to 4 GB, also manual
copy to that disk for a size more than 4 GB is okay.
Anyway, I have changed the format to NTFS and run a test again. May be a few
days will know if this will solve the problem.
Regards,
Anto
--
Thanks for your reply.
As I know, only FAT is limited to 4 GB, and manual copy to that disk that
exceed 4 GB it ok.
I will try to change to NTFS then.
---In firebird-support@yahoogroups.com, wrote:
On 24 Nov 2013 23:21:11 -0800, mailto:trskopo@...> wrote:
> Dear all,
>
> I have
Dear all,
I have a strange error message, tell me that there is not enough disk space
while actually it is enough space.
Here are the environment :
- database size is 4 GB, running on RAM Disk formatted as FAT32, free space
still 4 GB
- Firebird Super Classic 2.5.2 64 bit
- Windows 7 64 bit w
Hi all,
Anyone here already tried FB 3.0 Alpha?
I have installed it, and when when tried to connect via flamerobin, I got error
message :
GDS::Call()
Can't find or load fbclient.dll or gds32.dll
Environment : WinXp 64 bit, Superserver FB.
Any hints to fix it?
Thanks and regards,
Anto
Dear all,
Today, I faced same problem again, which is Firebird server became not
responsive.
Here are the latest settings :
- win 7 64 bit
- Firebirds 2.5.1 super server
- page size 8192
- page buffer 8192
- no long transactions
- temp cache limit set to 128MB
- there are a few numbers errors in
> I doubt 100%, but more than 16%, if the other connections/workloads
> forces the Firebird server process to be CPU bound.
>
> Check out my following demo video here, discussing SMP utilization with
> different Firebird architectures:
> http://www.iblogmanager.com/download/demos/firebird/fb25_a
> How do you know that you are CPU and not I/O bound?
>
> SuperClassic is capable to utilize SMP environments, but simplified one
> core per database connection. If you increase the number of database
> connections with CPU bound stuff, you should see an increase of CPU
> utilization.
>
>
> -
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
wrote:
>
> Perhaps the bottleneck is not the CPU, maybe your disk subsystem can't
> provide information as fast as the CPU can process it. I think your CPU
> is sitting idle while waiting the disc provides the data.
>
> I/O bound
Sorry, It it FB 2.5.2
> You didn't mention which FB version you are running.
>
> While SuperClassic is the future for FB, I must say that we only use/deploy
> Classic for all our installs (100+ servers around the world).
>
>
> Sean
>
Sorry, It is FB 2.5.2
> You didn't mention which FB version you are running.
>
> While SuperClassic is the future for FB, I must say that we only use/deploy
Classic for all our installs (100+ servers around the world).
>
>
> Sean
>
Hi all,
Using Firebird Super Classic in Win 7 64 on I7 2600K, I noticed that on a high
load, Firebird server never utilize cpu more than 16%.
Since the machine is a dedicated Firebird Server, are there any settings so
Firebird server can utilize more cpu?
Thanks and regrads,
Anto
Thanks for all replays.
I did a small test, here are the settings :
- FB Super Classic 2.5.1 64 bit
- Win7 pro 64 bit
- Database size about 640mb
- Select something like this :
select a.field1, b.field2, sum(c.field3)
from table1 a, table2 b, table3 c
where
group by
- temp directory set
Thanks for all replays.
I did a small test, here are the settings :
- FB Super Classic 2.5.1 64 bit
- Win7 pro 64 bit
- Database size about 640mb
- Select something like this :
select a.field1, b.field2, sum(c.field3)
from table1 a, table2 b, table3 c
where
group by
- te
Simple, i still have a lot of free RAM.
--- In firebird-support@yahoogroups.com, Doug Chamberlin
wrote:
>
> What are you seeing that makes you think your goal has not already been met?
>
>
> On Mon, Jul 15, 2013 at 12:38 PM, trskopo wrote:
>
> > Hi all,
> >
&
Hi all,
I have a 16GB RAM and since my database file is small size, it can completely
runs on RAM.
The problem is I can not set FB SuperClasic 2.5.1 on WinXp 64 to take
advantages of it.
Setting Page Size and Page Buffers is useless.
Performance seems just the same whether Page Size set to m
--- In firebird-support@yahoogroups.com, Jesús GarcÃa wrote:
>
> El 15/07/2013, a las 16:31, "trskopo" escribió:
>
> > Hi all,
> >
> > I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K.
> >
> > When data grows,
Hi all,
I have Superserver Firebird 2.5.1 installed on Win7 pro 64 bit on I7 2600K.
When data grows, Firebird Server starting to slow down. I shutdown Firebird
Server, starting again without changing anything and Firebird Server became
smooth again.
Any ideas, what is the problem with this? Fi
Hi all,
Suppose sql statement issued like this :
select * from table where field = 0
If this statement cached by TempCacheLimit, is memory consumption use by
TempCacheLimit released after statement finished or remain?
Also in Super Classic setting, TempCacheLimit shared or applies for each
co
Hi all,
I set temp directory for firebird 2.5.1 Super Server in firbird.conf like this :
TempDirectories =e:\;d:\temp
On Win 7 64, also set environment like these :
- FIREBIRD_TMP = e:\;d:\temp
- TEMP = e:\
- TMP = e:\
How do I know, firebird using that temporary directory?
Running a few query v
Hi all,
I have windows 7 64bit pro with intel I7 and firebird 2.5.1 Super Classic.
Should I turn HT on or off to boost firebird's performance?
On some app, when HT is on, performance decrease, what about for firebird?
Thanks and regards,
Anto
Hi all,
When database file placed on RAM, should I decrease or increase the value of
DefaultDbCachePages?
Does it has effects on performance, since database already placed on RAM?
Thanks and regards,
Anto
Hi all,
Suppose I have a table t1(f1 int, f2 int, f3 varchar(20)).
I want to create store proc to retrieve rows based on dynamic criteria.
Sometime, I want to retrieve rows that has f1 = 2 and f2 = 5, or want to
retrieve rows that only has f3 = 'abc', etc.
I can do that with 2 ways :
1) Create
Dear Bogdan,
I have already add index on snc field.
Thanks & Best regards,
Anto.
>
> Hi
>
> I would also add a compounded index snc + ID, or just snc
>
> Regards Bogdan
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
order by field_value,field_value2
>
> Good luck
> Alan
>
> Alan J Davies
> Aldis
>
>
> On 04/03/2013 06:18, trskopo wrote:
> > Hi all,
> >
> > I have a table with about 5,000,000 records and it's growing.
> >
> > I run slq statement
where field_value = 1 (and field_value2=2)
> order by field_value,field_value2
>
> Good luck
> Alan
>
> Alan J Davies
> Aldis
>
>
> On 04/03/2013 06:18, trskopo wrote:
> > Hi all,
> >
> > I have a table with about 5,000,000 records and it's gro
Hi all,
I have a table with about 5,000,000 records and it's growing.
I run slq statement like this :
Select * from table where field_value = 1.
Table already indexed on field_value (int type).
On local hardisk, where there is only 1 user and no update/edit/insert
operation, it took about
Hi Sean,
Thanks for your reply.
You were right, after fresh boot, test # 1 shows about same result with test #
3 & 4.
I think, test # 4, where database placed in harddisk, shows same result as
database placed in RAM, because database is small enough to cache in memory.
When I decreased Defaul
Hi all,
I run a test on a small database, around 128MB using Firebird 2.5 64 bit
superserver and the test condition is like these :
1) Put database completely on RAM, set DefaultDbCachePages = 2048 and
FileSystemCacheThreshold = 0
2) Put database completely on disk, set DefaultDbCachePages = 20
Hi all,
Is this setting apply to computer only have 1 cpu with multicore proc or only
apply to computer with have more than one physical cpu?
Thanks and regards,
Sugi
> "telnet 3050" should let you test to see if that port is
> accessible and listening.
>
> -steve
>
>
> On Mon, Nov 12, 2012 at 8:36 PM, trskopo wrote:
>
> > **
> >
> >
> > Hi Baskin,
> >
> > Thanks for your reply.
> >
&
y disable the port and re-try telnet and
> connection. If successful, you can add port exceptions to your firewall and
> turn it back on.
>
> Hope this helps,
>
> Baskin
>
> --- In firebird-support@yahoogroups.com, "trskopo" wrote:
> >
> > Hi
Hi all,
I have installed Firebird 2.5.2(64bit) Superserver on CentOS 6.3 (64 bit).
This CentOs server running on Virtual Box as a guest system. Host system is Win
7 64 bit.
I can ping server's ip address but failed to connect to Firebird via flamerobin
installed on Win 7.
I got an error messa
--- In firebird-support@yahoogroups.com, "ma_golyo" wrote:
>
> FB has VERY poor performance with EXT4
>
> http://www.firebirdnews.org/?p=6421
>
>
Hi ma_golyo,
Thanks for the tip.
After I read that article, if I am not mistaken, Barriers setting in ext4 cause
poor performance.
Do you know
--- In firebird-support@yahoogroups.com, "ma_golyo" wrote:
>
> FB has VERY poor performance with EXT4
>
> http://www.firebirdnews.org/?p=6421
>
>
Hi ma_golyo, thanks for the tip.
Sugiarto
Hi Dmitry Kuzmenko,
Thanks for your reply.
> 1. Windows can be better or slower than Linux on same hardware,
> depends on hardware and existing drivers for hardware for Linux and
> Windows. Difference can be up to 30% of performance.
>
1) What drivers in that should exist for better performanc
Hi Lester,
Thanks for your reply.
>
> So the question should perhaps be ... what are you using with Firebird?
>
I am using firebird in client-server environment for accounting application and
mostly only in a LAN.
About file system, (if I didn't mistaken) someone here mentions not to use
s
Hi all,
I am considering moving from windows to linux, but not sure if it is a good
idea.
Any one can give me a hints about this matter?
Is it Linux better than windows on the same hardware, regarding
performance/security/etc?
And if it's better, what distro should I choose and what file sy
Ah, that's right, using having clause is much more simple, thanks a lot for
that tip.
Sugi
> Have you considered just
>
> select id_cst,id_gd,sum(qty) qtySum from Tbl1
>group by id_cst,id_gd
>having qtySum > 0
>
> There's a slight benefit to the view or stored p
Hi all,
I have a table, let say Tbl1, which structure something like this
id_cst int, id_gd int, qty int.
I want to select from that table, all records that has sum(qty) > 0 group by
id_cst and id_gd.
I have 2 options to do that :
1) create a view with a ddl like this :
create view tmp (id_
;
> --- On Thu, 8/16/12, trskopo wrote:
>
> From: trskopo
> Subject: [firebird-support] Help, how to connect to firebird via Internet
> To: firebird-support@yahoogroups.com
> Date: Thursday, August 16, 2012, 4:10 AM
>
>
>
Hi all,
I have setup a dynamic ip address via www.no-ip.com and got a domain name.
I can ping from windows this domain(by its name or ip address), but when I
using flamerobin to connect to this domain, it failed.
In flamerobin, i enter this domain name as a hostname in Server registration
In
Hi all,
Is this possible to create stored proc with dynamic parameter as an input?
For example, I have a table like this :
id value
== =
1 'A'
2 'B'
3 'C'
4 'D'
5 'E'
How to create stored proc to returns values from above table but with dynamic id
as an input?
For ex, how to return values,
Hi all,
Is this possible to create stored proc with dynamic parameter as an input?
For example, I have a table like this :
id value
== =
1 'A'
2 'B'
3 'C'
4 'D'
5 'E'
How to create stored proc to returns values from above table but with dynamic
id as an inp
> > 2) Pen Drive : more compact.
> >
>
> Welcome to our recovery service :)
Yes, Pen Drive is really not reliable, prepare to lost you data if you using
this media, that why I said USB Hardisk is more reliable compare to Pen Drive :)
>
> >
> > 3) RAM Disk : highest speed but risky and less spac
On my experience :
1) USB HDD : more reliable, more speed and more space.
2) Pen Drive : more compact.
3) RAM Disk : highest speed but risky and less space. Do not use it unless you
aware of the risk. Runs on a dedicated PC (no other programs run on this pc,
only database server and OS), backu
I use FB 2.01 in external USB drive connected to the server for about 3-4
years. No problem at all, I think FB 2.5 won't be a problem too.
Currently, using FB 2.5 on a RAM Disk (in server) for a better speed.
incendio.
--- In firebird-support@yahoogroups.com, "Sergio H. Gonzalez"
wrote:
>
> He
Yes, I understand, this is for test only.
Thanks and regrads,
Sugiarto
--- In firebird-support@yahoogroups.com, Lester Caine wrote:
>
> trskopo wrote:
> > 3) change id's column def
> > UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1
> > WHERE RDB$FIELD_NAME = '
Thanks for your reply.
I did another test, just to make sure.
1) Create a test table
create table test (id int, nm varchar(12));
2) insert some values
insert into test (nm) values('test1');
insert into test values(2, 'test2');
3) change id's column def
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_F
Thanks for your reply.
I think my database is in problem, because when I tried to restored it, I got
error
Engine Message :
validation error for column ID_DIV_LC, value "*** null ***"
warning -- record could not be restored
I think, may be there is a leak in Firebird to trap an error when null
Thanks for your replay.
If you see null with ibexpert, how come this data can be store in Firebird,
since ddl for this column not allow for null value? Could it be a bug in
Firebird?
Another strange results when issued this statement
SELECT * FROM M_INT_FRM a
where a.id_div_lc is null
It will
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
wrote:
>
> Em 7/5/2012 21:51, trskopo escreveu:
> > Hi all,
> >
> > I run sql statement via flamerobin, the statment is like this :
> >
> > SELECT * FROM M_INT_FRM a
> > where
Hi all,
I run sql statement via flamerobin, the statment is like this :
SELECT * FROM M_INT_FRM a
where a.ID_TRS_TYP = 100
It will returns :
ID ID_DIV_LC SCT_INI ID_TRS_TYP FRM_INI
4 8 MP 100PO
5 9 MN 100PO
6
Hi all,
I want to record all changes in tables (insert/update/delete).
I can do this by creating triggers for each tables, triggers ex :
SET TERM ^ ;
CREATE TRIGGER UPD_M_AREA FOR M_AREA ACTIVE
AFTER UPDATE POSITION 10
AS
BEGIN
insert into log (id_tbl,tbl_nm, opr)
values(new.ID, 'M
gt; On Thu, Jan 19, 2012 at 11:46 PM, trskopo wrote:
>
> > **
> >
> >
> > Hi all,
> >
> > Suppose I have a sql statement :
> > select * from table
> >
> > Is that possible to return only a few rows from that statement (not the
> > whole
WHERE clause.
>
> Greetings.
>
> Walter.
>
>
>
> On Thu, Jan 19, 2012 at 11:46 PM, trskopo wrote:
>
> > **
> >
> >
> > Hi all,
> >
> > Suppose I have a sql statement :
> > select * from table
> >
> > Is that possi
Hi all,
Suppose I have a sql statement :
select * from table
Is that possible to return only a few rows from that statement (not the whole
result), just like MySQL?
Thanks and regards,
Sugiarto
> from where and how did you get such message ?
> what did you did ?
>
> under CentOS 6.2 use EPEL repository, you have Firebird packages inside
>
> http://fedoraproject.org/wiki/EPEL
> http://fedoraproject.org/wiki/EPEL/FAQ
When I double click this file FirebirdSS-2.5.1.26351-0.amd64.rpm and
> You could to install from :
> for linux platform -
> http://www.firebirdsql.org/en/firebird-2-5-1/#Linux_AMD64
> for windows platform http://www.firebirdsql.org/en/firebird-2-5-1/#Win64
>
> x86 is for 32 bit compatible processors and AMD64 is for 64 bit
> compatible processors .
>
> --
> Re
Hi,
Someone in this forum said that raid 5 is bad for firebird server.
Regards,
Sugiarto
--- In firebird-support@yahoogroups.com, "Ismael L. Donis Garcia"
wrote:
>
> For my understanding I raid 5 or raid 0
>
> Best Regards
> =
> || ISMAEL ||
> =
> - Original Message -
Hi all,
Is there firebird 2.5 64 bit version for Intel proc?
I have already tried to install firebird 2.5 for Linux AMD64 on Intel proc, but
no avail.
Thanks in advance.
Regards,
Sugiarto.
> Linux and Windows has the same Forced Writes setting?
Yes, both, Force Write = On
Regards
> I have had a look at your database and it looks like you have been testing
> on Centos using a page cache of 75 (I suspect you may have classic
> installed) - this results in the large number of reads on Centos and
> therefore the slower execution/fetch time.
> Edit your firebird.conf file (most
> I mean: How to create a ram disc?
There is a software to create ram disk, a free one and commercial.
Free version can store up to 4GB.
But RAM disk, if I don't mistake, can only do in WIN OS.
Backup from/to RAM disk is very2 fast.
Regards,
Sugiarto
Hi David,
Thanks for your reply. I am out of town right now. I will check firebird's
setting on CentOs when I am at home.
Best regards,
Sugiarto
>
> Check DefaultDbCachePages in Windows and Linux.
>
> Classic has 75 SuperServer 2048.
>
> Is it the same DefaultDbCachePages for both Operative System?
>
> Regards
I use SuperServer mode both in CentOS 6 and Win 7.
I don't know why performance on CentOS 6 is so bad. I will try again in Cen
--- In firebird-support@yahoogroups.com, yanto_asnawi@... wrote:
>
> I Use firebird classic server
> And only few service daemon run,
> Memory use after restart only 64mb (check with free)
If you don't mind, please download my test data and run a test on your server
with this data, I would like
Here is the result on WinXp 64 bit, Firebird 2.5 SuperServer, RAM 2GB, Database
on Hardisk
Executing...
Done.
8432701 fetches, 2 marks, 0 reads, 2 writes.
0 inserts, 0 updates, 0 deletes, 4143977 index, 0 seq.
Delta memory: 78928 bytes.
Total execution time: 7.104s
Script execution finished.
Loo
In case someone interested to do the same test, you can download test data at
http://www.mediafire.com/file/qjcw0q6gsq51wny/dba.7z
Hi all,
I did a little test about Firebird 2.5 SuperServer 64 bit performance on these
2 OS.
Both running on the same cpu, others setting are
1) CentOS 6 : RAM 2GB, file ext4, database on disk
2) Win 7 : RAM 4GB, database on RAM
Table structure for this test :
CREATE TABLE DT_LOG
(
DT Date DE
--- In firebird-support@yahoogroups.com, yanto_asnawi@... wrote:
>
> Hi,
> I use intel core i7 and centos 6 64bit
> Harddisk raid level 0, SATA wetern digital raptor
>
> performance : excellent.
>
Thanks for your reply. Could you be more specific about your specs for I7 and
wd raptor?
Also,
Hi all,
I am looking for CPU for Firebird database server, which one is better
between Intel I7 and AMD Phenom II X6, OS is Windows XP 32 bit or CentOS 6 64
bit.
Thanks in advance.
Best regards,
Sugiarto.
Hi all,
I am planning to use CentOS 6 for Firebird 2.5 server(Super Server mode), but I
am really a newbie in Linux.
In CentOS, I can only install firebird, setting sysdba password, setting TCP/IP
manually, setting file permissions and setting Firewall, that's all. I have
tried these steps, a
It is possible but you must have static ip address and do some port forwarding
on your router.
Incendio.
--- In firebird-support@yahoogroups.com, W O
wrote:
>
> Hello everybody
>
> I know that I can connect to a data base writing something like:
>
> CONNECT 80.51.2.3:C:\Databases\MyDataBase.
Hi all,
Suppose I have this setting :
- Firebird in SuperServer mode
- a Database with Page Size 8192, Page Buffers 2048
- Database cache in firebird.conf = 2048
How many RAM needed per one connection? Is this depend on OS?
Thanks in advance and best regards,
Incendio
Hi Milan,
I use Win 7 64, 8GB RAM
Incendio
--- In firebird-support@yahoogroups.com, Milan Babuskov wrote:
>
> trskopo wrote:
> > I just doing a little experiment to find out database performance on RAM vs
> > on Disk.
>
> Which operating system do you use?
&
Hi Mark,
Thanks for your answer.
Best regards,
Incendio
--- In firebird-support@yahoogroups.com, Mark Rotteveel wrote:
>
> On 29-10-2011 9:54, trskopo wrote:
> > Hi all,
> >
> > Is this Firebird for Linux AMD64 only runs on AMD's CPU?
>
> Now, it also runs
wrote:
>
>
> On 2011-10-27, at 7:56 PM, trskopo wrote:
>
> > Hi all,
> >
> > I just doing a little experiment to find out database performance on RAM vs
> > on Disk.
> >
> > I use WD SATA 2 Green, 64MB cache for testing. My RAM speed is ab
Hi all,
Is this Firebird for Linux AMD64 only runs on AMD's CPU?
Thanks and best regards
Incendio
Hi all,
I just doing a little experiment to find out database performance on RAM vs on
Disk.
I use WD SATA 2 Green, 64MB cache for testing. My RAM speed is about 35x faster
than disk.
I have 2 databases (size is about 75 MB), one placed on a RAM and the other on
disk, then I run select sql fo
Hi all,
Usually, I am using firebird in a small client server environment ( 1 server
and up to 5 clients). For Server, I use a desktop pc. It runs ok, though there
was performance decrease when reports generated.
Database size relatively small, under 300 MB after 3 years.
Now, I have a need to
d best regards,
Sugiarto.
--- In firebird-support@yahoogroups.com, Philippe Makowski wrote:
>
> 2011/9/11 trskopo
> >
> > I have installed Firebird in CentOS 5.4.
> how ?
> Classic or SuperServer ?
> is Firebird service or Xinetd running ?
>
--- In firebird-support@yahoo
rebird-support@yahoogroups.com, Philippe Makowski wrote:
>
> 2011/9/11 trskopo
> >
> > I have installed Firebird in CentOS 5.4.
> how ?
> Classic or SuperServer ?
> is Firebird service or Xinetd running ?
>
Hi, thanks for your reply.
Firebird in Superserver and service already running.
Best regards,
Sugiarto.
--- In firebird-support@yahoogroups.com, Philippe Makowski wrote:
>
> 2011/9/11 trskopo
> >
> > I have installed Firebird in CentOS 5.4.
> how ?
> Classic or Sup
Hi all,
I have installed Firebird in CentOS 5.4. Installation was ok, but i failed to
connect to firebird via flamerobin from Windows client.
I can ping the CentOS IP address, but when tried to connect via FlameRobin, I
got err msg "unable to complete to network host".
(I have filled this IP ad
Hi Alan, thanks for your answer,
My SQL statement is like this :
select a.*, b.nm from T_IN_OT1 a, m_src b
where a.is_cls <> 'T'
and a.id_cst_sppl = b.id
order by a.frm_N desc
Before run this statement, I call stored procedure to calculate stock
calculation, it is quiet a heavy procedure.
I am
Hi all,
I want to set CpuAffinityMask value in firebird.conf for multicore.
The description in that file told me that to use only first processor, the
value is 1, to use both # CPU 1 and CPU 2, the value is 3.
What is the value if I want to use # CPU 1, CPU 2, CPU 3, and CPU 4? Also the
value
Hi Cornie, thanks for your answer.
I am using TIBQuery and there is no PacketRecords and FetchOnDemand property
for TIBQuery.
Best regards,
Sugiarto
--- In firebird-support@yahoogroups.com, Cornie van Schoor wrote:
>
> On 03/09/2011 13:54, trskopo wrote:
> >> Hi all,
> &
Hi Alan, thanks for your answer,
My SQL statement is like this :
select a.*, b.nm from T_IN_OT1 a, m_src b
where a.is_cls <> 'T'
and a.id_cst_sppl = b.id
order by a.frm_N desc
I am using AMD 6 cores only for testing, because the application is not
complex, and I believe Intel Dual Core E5700 i
Hi all,
I have a problem with Firebird-2.1.0.17798_0_Win32, running on Win7 32 bit Home
Basic with 1 Gb RAM. CPU is Intel Dual Core E5700 (3 MHz). I am using C++
Builder 6 as a development tool.
Here is the problem, when I issued Select SQL statement, sometime, not all
records fetched, but thi
uperserver supported for multicore, right?
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
wrote:
>
> Em 26/8/2011 20:34, trskopo escreveu:
> > Hi all,
> >
> > If it can running on multi core, how to set that? It seems, setting
> > CpuAffinityMask in fir
Hi all,
If it can running on multi core, how to set that? It seems, setting
CpuAffinityMask in firebird.conf has no effect.
Thanks in advance.
Best regards,
Sugiarto.
Hi all,
If it can running on multi core, how to set that? It seems, setting
CpuAffinityMask in firebird.conf has no effect.
Thanks in advance.
Best regards,
Sugiarto.
Dear Thomas Steinmaurer,
Thanks for your reply.
I don't give SysDba password to users, but since Firebird is freely available,
it is easy for users to install Firebird in his/her computer and copy my
database to this computer and then disable triggers in my database using
his/her new SysDba pa
Hi all,
For a security reason, I wrote a database triggers. It can prevent unauthorized
users to connect to database.
Access from application or database managers (such as flamerobin/others) can be
blocked if needed.
But the problem is, users can disable / set inactive my db triggers via ISQL.
97 matches
Mail list logo