--- In firebird-support@yahoogroups.com, "nathanelrick"
wrote:
>
> > Update Session Set
> > data=...
> > Expiry_date= NOW + 15minutes
> > where
> > id=... and
> > Date_expired > DATEADD(-5 minute to CAST('now' AS TIMESTAMP))
>
> ok, in fact we already do like this, but by 1 minute instead
> Update Session Set
> data=...
> Expiry_date= NOW + 15minutes
> where
> id=... and
> Date_expired > DATEADD(-5 minute to CAST('now' AS TIMESTAMP))
ok, in fact we already do like this, but by 1 minute instead of by 5 minutes
... :(
> I would be interested in a "gstat -r -i " output before
> and after the update statement.
Database header page information:
Flags 0
Checksum12345
Generation 24711032
Page size 8192
ODS version
Hello Thomas,
> I would be interested in a "gstat -r -i " output before
> and after the update statement.
i launch the gstat -r -i as soon as i read you message but still
running ... so it's take lot of time to analyze :(
a soon as i have the result i will post it here ...
> i am curious why do you use also date - not only id in this statement?
> id is not primary key?
yes id is the primary key (the session ID), but when i retrieve a session, i
want only session that are not yet expired (if not session ID is not to be used
anymore and new session ID must be recre
Thanks svein,
this is the database statistics
Flags 0
Checksum12345
Generation 24702533
Page size 8192
ODS version 11.2
Oldest transaction 24694658
Oldest active
--- In firebird-support@yahoogroups.com, "nathanelrick"
wrote:
>
> Hello,
>
> I have a table that i use to store session
>
> Table Session
> ID: VARCHAR(16); /* GUID ID */
> Expiry_date: Timestamp;
> Data: Varchar(1000);
>
> i use the table like this only :
>
> Insert into Session(ID,Expiry
>> How many records approx.?
>
> ok, the select count(*) return ... 4 300 000 record (for last 3 days)
A select count(*) basically touches all records in question and might
invoke garbage collection if record versions aren't interested for other
transactions anymore.
I would be interested in a
Yes i know, but i do day - 3 to be absolutely sure that nothing is trying just
even to read the row i actually deleting (because i always have some deadlock i
don't understand why or with wait it's soo long that i not understand)
--- In firebird-support@yahoogroups.com, "nathanelrick"
wrote:
>
>> How many records approx.?
>ok, the select count(*) return ... 4 300 000 record (for last 3 days)
What are the statistics of that database? I just counted 3.6 million records in
1 min 18 seconds (albeit that table contains 50 years of history, not 3 days,
so the system isn't anywhere as busy
d
Tel (+27) (0)21 684 3525
Fax (+27) (0)21 684 3225
Cell (+27) (0)82 747 6127
Email: vince.dug...@virginactive.co.za
Live happily ever active
From:
"nathanelrick"
To:
firebird-support@yahoogroups.com
Date:
2012/02/29 08:34 AM
Subject:
[firebird-support] Re: Update take hours to delet
> How many records approx.?
ok, the select count(*) return ... 4 300 000 record (for last 3 days)
not bad idea ! i will try like this to see because for now it's a disaster
:( but i m also afraid the the garbage is also in something that explain the
slow :(
--- In firebird-support@yahoogroups.com, vince.duggan@... wrote:
>
> Hi,
>
> I see from other emails that you have had a few dis
> How many records approx.?
one hours a go i just do an select count(*) from session but still now answer
so i thing a lot ...
> By using isc_tpb_no_rec_version you basically disable Firebird's MVCC
> capabilities, so you explicitly tell Firebird to not use the back-record
> version mechansim
14 matches
Mail list logo