Hello, i'm trying to understand the memory usage with classic server 2.5.2,
cache pages 300.
Our production database, once one form is opened, uses 12 Kb memory,
and the memory is allocated the first time a form that open a set of tables
that is related with many other tables in the database
Thanks Svein,
Is your query,
select IDObj From DESCRIPTION where ID='ID_HAS_NEVER_EXISTED', or
select IDObj From DESCRIPTION where
ID='ID_THAT_IS_RECENTLY_DELETED_UPDATED_OR_ADDED'?
First case ID='ID_HAS_NEVER_EXISTED', so unfortunatly it's not this ..
also i do the test on a fresh
Did you grant the necessary rights to the trigger itself? I might be
wrong, but if no rights are granted to the trigger, then the caller
permission is used.
I can't figure out how to associate a role to a trigger.
I gave all privileges to the trigger on its table but that did not help.
(I'm
I gave all privileges to the trigger on its table but that did not help.
What do you mean by 'its table'? Grant the trigger rights to the table it
should insert/update, e.g.
GRANT ALL ON TABLE1_PRIVILEGES TO trigger;
HTH,
Set
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
Is your question theoretical for some kind of case study or DBMS
comparison thingy or did you hit a limit already? Just curious. ;-)
In really, is a practical question.
I have to classify some records (about 300k) in
On Wed, 07 Mar 2012 11:34:09 -, Cristiano boxferr...@gmail.com
wrote:
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@...
wrote:
Is your question theoretical for some kind of case study or DBMS
comparison thingy or did you hit a limit already? Just curious. ;-)
In really,
THE DDL of the 3 sample table :
CREATE TABLE DESC_VARCHAR (
IDOBJ VARCHAR(20),
COMMENT VARCHAR(1)
);
CREATE INDEX DESC_VARCHAR_IDX ON DESC_VARCHAR(IDOBJ);
CREATE TABLE DESC_BLOB (
IDOBJ VARCHAR(20)
COMMENT BLOB
);
CREATE INDEX DESC_BLOB_IDX ON DESC_BLOB(IDOBJ);
nathanelrick [2012-03-07 13:33] :
if you understand something . moving the page size from 8 to 16 reduce by
10 the speed of the 2 first query, but still 10x more slower than the last
variante
obviously there are less data pages to read for the third table
see gsat -d result for these
THE DDL of the 3 sample table :
CREATE TABLE DESC_VARCHAR (
IDOBJ VARCHAR(20),
COMMENT VARCHAR(1)
);
CREATE INDEX DESC_VARCHAR_IDX ON DESC_VARCHAR(IDOBJ);
CREATE TABLE DESC_BLOB (
IDOBJ VARCHAR(20)
COMMENT BLOB
);
CREATE INDEX DESC_BLOB_IDX ON
Aldo Caruso wrote:
Which are the steps to follow to backup and restore database users and
passwords ?
I usually just stop the server and copy security2.fdb file. Unlike the
databases, it is rarely written to. I mean, how often do you open new
user accounts.
--
Milan Babuskov
No one? My (probably unjustified) fear is that since the variables are
stored in a four byte primitive instead of a packed-decimal like format,
I may randomly run in to this.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of
No one? My (probably unjustified) fear is that since the variables are
stored in a four byte primitive instead of a packed-decimal like format,
I may randomly run in to this.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On
On Wed, Mar 7, 2012 at 1:25 AM, nathanelrick nathanelr...@yahoo.fr wrote:
yes Rick, but what will be my job after :( i will be fired because i will
become useless :(
but what the specialist will say me here ? yes it's a true disaster, the
index entries are spawn in the record page, mean that
OK, thank i see now exactly where is the probleme is
it's in the PREPARE step
select IDObj From desc_varchar where IDObj='NOT_EXIST';
PREPARE_STATEMENT: 40 ms
EXECUTE_STATEMENT_FINISH: 0 records fetched
0 ms, 4 read(s), 4 fetch(es)
select IDObj From desc_blob where
You've presented the list with a problem that we haven't been able to solve
given the information available. And no, the index entries are NOT spawn
in the record page - index entries use only the key values, they're stored
on index pages, and they're prefix compressed. I haven't a clue what
15 matches
Mail list logo
