Hello,
Don't store sessions in table - it's not MySQL.
When you'll issue SELECT count(*) to count them, you'll see delays.
Use NoSQL frameworks for this purpose.
Regards,
Alexey Kovyazin
IBSurgeon
Hello,
I have a table that i use to store session
Table Session
ID: VARCHAR(16); /* GUID ID
Thanks svein,
this is the database statistics
Flags 0
Checksum12345
Generation 24702533
Page size 8192
ODS version 11.2
Oldest transaction 24694658
Oldest active
Hello Thomas,
I would be interested in a gstat -r -i yourdatabase output before
and after the update statement.
i launch the gstat -r -i yourdatabase 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 would be interested in a gstat -r -i yourdatabase output before
and after the update statement.
Database header page information:
Flags 0
Checksum12345
Generation 24711032
Page size 8192
ODS
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
... :(
Unfortunetly this is not that case
trigger is linked to good table and i never change it
Karol Bieniaszewski
--- In firebird-support@yahoogroups.com, nathanelrick nathanelrick@...
wrote:
I don't know if it can help but
when you do CREATE TRIGGER TRIG_OPIS_DB_ID FOR OldTable ACTIVE
that ok
--- In firebird-support@yahoogroups.com, nathanelrick 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
Mags Phangisa wrote:
Is there a way I can import data from a spreadsheet into a table? Any help
will be greatly appreciated.
Save to CSV format and use XMLWizard:
http://www.guacosoft.com/xmlwizard
It can detect and suggest datatypes, table structure, etc.
--
Milan Babuskov
I just did a test in our environment. I logged into the database and made a
change. The date modified on the database file wasn't updated. But when I
logged out of the database, the date modified was updated. I was the only
one logged into the database at the time.
I logged into a
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
I just did a test in our environment. I logged into the database and made
a change. The date modified on the database file wasn't updated. But when
I logged out of the database, the date modified was updated.
Do a database backup just before the incremental backup and that backup file
will get backed up. The incremental backup of the database may not be any
good if there are connections to the database.
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf
--- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@... wrote:
I just did a test in our environment. I logged into the database and made
a change. The date modified on the database file wasn't updated. But when
I logged out of the database, the date modified was updated. I
Hi,
you could be happy the database was missed, because one of the few things to
create a defect firebird database is copying the database while it has active
connections.
I use GBAK to create automated backups of my databases every night. You can do
that with a live database and even with
hello,
i do some more tests to investigate ...
* When the table is read only by a single user (or very few user) speed is fast
(around 30 ms by select)
* when the table is read by more users (around 50), then the speed go down !
around 500 ms by select
* When the table is also updated by
I have heard that you can corrupt a database when copying it with active
connections. I am wondering if incremental windows backups are different than
a 'copy'.
We have a number of clients that have Network administrators with larger
networks. I am certain many run incremental backups on
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
--- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@ wrote:
I just did a test in our environment. I logged into the database and
made a change. The date modified on the database file wasn't updated.
todderamaa wrote:
We just had an issue at a site and the client was thinking they could use
their Incremental Backups on their network to solve the issue. They were
surprised to see that the database was being missed This is why I posted to
find a solution.
I think that probably answers
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from backup entirely and only backup the gbk files
that are created in the evening.
This is the usual way to backup Firebird databases in situations like
your clients
--- In firebird-support@yahoogroups.com, Doug Chamberlin chamberlin.doug@...
wrote:
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from backup entirely and only backup the gbk files
that are created in the
Doug,
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from backup entirely and only backup the gbk files
that are created in the evening.
This is the usual way to backup Firebird databases in situations like
On 2/29/12 3:30 PM, todderamaa wrote:
--- In firebird-support@yahoogroups.com, Doug Chamberlin
chamberlin.doug@... wrote:
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from backup entirely and only backup the
On 2/29/12 3:28 PM, todderamaa wrote:
But with this latest issue, we needed the database file and not the
backup. The restore of the backup failed, because we had a stored
procedure that was selectable that didn't include a 'suspend'
statement. I think this must be something that was allowed
Doug,
If Firebird's' classic architecture is being used then each process accessing
the
file can read it. However, it's hard to imagine a read-only file access would
corrupt the file being read.
Perhaps better experts than I can give you a more definitive answer.
We have over 100
On 2/29/12 3:47 PM, Leyne, Sean wrote:
The NBackup functionality allows a database file to be quiesced (with
changes written to a delta file) to allow for OS level backups to be
performed (thru Lock and Unlock options).
But doesn't that just move the potential conflict to the delta file,
Den 2012-02-29 22:22 skrev Doug Chamberlin såhär:
On 2/29/12 3:47 PM, Leyne, Sean wrote:
The NBackup functionality allows a database file to be quiesced (with
changes written to a delta file) to allow for OS level backups to be
performed (thru Lock and Unlock options).
But doesn't that
Doug,
The NBackup functionality allows a database file to be quiesced (with
changes written to a delta file) to allow for OS level backups to be
performed (thru Lock and Unlock options).
But doesn't that just move the potential conflict to the delta file, leaving
you
with the same issue
Kjell,
I did have some issue with it 1-2 years ago, with a rather large DB.
Some problem with transaction commit during nbackup locked state. I never
had time to investigate if it was really caused by nbackup, but it only
happened in that state...
A review of the project tracker finds that
Sean,
I did have some issue with it 1-2 years ago, with a rather large DB.
Some problem with transaction commit during nbackup locked state. I never
had time to investigate if it was really caused by nbackup, but it only
happened in that state...
A review of the project tracker finds that
Thomas,
To quote Dmitry from a few weeks ago (around mid Jan. 2012), the usage of
nbackup in 2.1 with Classic under high load can be problematic. It seems
that there was quite a re-write in 2.5 though.
I believe that his comment was related to the use in creating backup, not in
locking the
Sean,
To quote Dmitry from a few weeks ago (around mid Jan. 2012), the usage of
nbackup in 2.1 with Classic under high load can be problematic. It seems
that there was quite a re-write in 2.5 though.
I believe that his comment was related to the use in creating backup, not in
locking the
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
--- In firebird-support@yahoogroups.com, Doug Chamberlinchamberlin.doug@
wrote:
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files
--- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@... wrote:
--- In firebird-support@yahoogroups.com, Doug Chamberlinchamberlin.doug@
wrote:
On 2/29/12 2:50 PM, todderamaa wrote:
Maybe with the possibility of corruption, I should tell him to exclude
the database files from
32 matches
Mail list logo