Hi guys.
When I came to work for my current company, I saw something that I had never
seen before (Back then I had 5+ years of experience working with various SQL
Server DBs):
on each table in database there is a trigger which is fired up before updating
the row. The trigger makes a copy of
You could give the following settings a try:
Page Size: 16K
Page Buffers: 2048
TempCacheLimit in firebird.conf: 134217728
LockHashSlots in firebird.conf could be increased as well, e.g: 10009
Thank you, I give those settings a try. Firstly I need to back up/ restore
the DB and it will
Hi guys.
When I came to work for my current company, I saw something that I had never
seen before
(Back then I had 5+ years of experience working with various SQL Server DBs):
on each table in database there is a trigger which is fired up before updating
the row.
The trigger makes a copy of
Nope. Just adding or updating a child which points to a parent. The FK
field of the child is never changed, nor the PK of the parent. So I
don't know how a FK constraint can be violated.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
11.10.2012 10:02, kokok_kokok wrote:
Is there a place when I send you the database?
firebird2 at yandex dot ru
Dmitry
-- Original Message ---
From: y_ongky_s ongk...@gmail.com
So the procedure work by deleting old records and then create new
records with insert command.
The problem is after records deleted from stock card table it create
garbage collection and slow down
the process when the
Thanks, we'll be implementing this. Hopefully Firebird will get
deferred constraints and I'll be able to tackle the other half of our
problem.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of unordained
Sent: Monday, May 14,
Ongky,
When i recalculate stock card first I delete the records and then I
rebuild
it with data collected from another tables. The stock card is to store
the summary of stock
transaction.
Can you drop the stock card table instead? That would require that no
running connection have
On Thu, Oct 11, 2012 at 2:20 PM, Ann Harrison aharri...@ibphoenix.comwrote:
Ongky,
The problem is after records deleted from stock card table it create
garbage collection and slow down
the process when the procedure start to rebuild the stock card by
inserting new records into it.
Are
I am using FB 2.5.1 on Windows 7 64 bits.
It works perfectly on FlameRobin 0.9.3.2219 Unicode (x64):
---
Create Database test.fdb Default Character Set utf8;
Create Table test15 External 'c:\mytable15.txt'
(
code1 Integer,
code2 Integer,
namechar(20),
born
10 matches
Mail list logo