As far as I can tell from gstat output there are no old versions, which
suggests that either I am misunderstanding what gstat is telling me or
this explanation is not the answer to my problem.
I see zero writes doing the count(*).
On 09/08/2013 20:15, Ann Harrison wrote:
Karol Bieniaszewski
Hi,
Put info from gstat or send it to me priv
Also output from mon$ tables.
Regards,
Karol Bieniaszewski
- Reply message -
Od: Tim Ward t...@telensa.com
Do: firebird-support@yahoogroups.com
Temat: Odp: [firebird-support] Performance with heavily updated table
Data: pon., sie 12, 2013
I believe the relevant part of the gstat output for the table in
question to be as below, please let me know if I've got that wrong.
(Names changed but otherwise unaltered.) My interpretation, which may be
faulty, of
Average version length: 0.00, total versions: 0, max versions: 0
is that
Dear,
as I can move my firebird database unit to unit c :/ d :/ Thanks
--
[Non-text portions of this message have been removed]
Dear,
I have three file from my database: c :/ datos_1.fdb, datos_2.fdb c :/ c :/
datos_3.fdb;
all of them form a single database, and I can move the segment c :/
datos_3.fdb, to another disk, thanks.
[Non-text portions of this message have been removed]
http://tkb.amano.com/phpkb/article.php?id=181 could help.
Regards.
El 12/08/2013 01:36 p.m., Marco Sucuzhañay escribió:
Dear,
I have three file from my database: c :/ datos_1.fdb, datos_2.fdb c :/ c :/
datos_3.fdb;
all of them form a single database, and I can move the segment c :/
Hello, Jorge!
Monday, August 12, 2013, 8:54:17 PM, you wrote:
JAB http://tkb.amano.com/phpkb/article.php?id=181 could help.
really? This piece of auto-generated crap can help?
You read the description of that solution? :-)
In the case of moving db+secondary files
the only HEX editor, or old
At 06:05 a.m. 13/08/2013, Thomas Steinmaurer wrote:
Multi-file Firebird database are an ancient feature to overcome certain
size limitation of file systems. Are you really in need of having a
multi-file database?
Agree 101%. I cannot even think of a good reason why that existing database is
Mark Rotteveel wrote:
I am unable to reproduce it. Could you create a simple reproduction script
that creates the table, adds the testdata and includes the query?
My reproduction is:
CREATE TABLE int_date_table
(
intfield INTEGER,
datefield DATE,
timestampfield TIMESTAMP
);
Make
I managed to get around it as follows, but I'd say it is a bug:
What I wanted to do:
case
when ((p.StartDate = cast('Today' as date)) and (p.EndDate =
cast('Today' as date))) then
(cast('Today' as date) + 1)
else
p.enddate + 1
end
What I
10 matches
Mail list logo