I am using the FlameRobin tool to execute the query.
I write the select query like select first 100 * from XXX , I am able to get
the result.
But when use one more query select first 110 * from XXX , I am not able to get
the data,
still it is in process to get the Data. I am surprise for
Hello John,
You have hit transaction limit of Firebird.
To prevent it, make backup/restore more often.
Regards,
Alexey Kovyazin
IBSurgeon
Our main database is Firebird 2.1 running on a windows 2k8 server
In the middle of the night with no real users, a single program was
running updating
Hi John,
Our main database is Firebird 2.1 running on a windows 2k8 server
In the middle of the night with no real users, a single program was running
updating data from a file into the database. This runs every night, there
were no changes to the programs and automatic server updates are
Hi,
I've archived some old FDB files since my Win2000 (32 bit) days, and
unfortunately some of them are available only in FDB form, not as a
backup file.
Is there any way I can get access to them on my current 64 bit system
with only 64 bit Firebird installed?
No problem having to go via
Hi John,
Something to look at is any heavy use of blobs and long-running transactions
within the application as these may point to your problem.
HTH,
Tom
--- In firebird-support@yahoogroups.com, dr_john_mp dr.john@... wrote:
Our main database is Firebird 2.1 running on a windows 2k8 server
If you dont want to install the 32 Bit Version on your 64 Bit (Windows 7)
simply install
Windows Virtual PC and XP 32 in it. For Windows 7
Professional/Ultimate/Enterprise its free.
I use it for such things.
http://windows.microsoft.com/de-de/windows7/products/features/windows-xp-mod
e
I've archived some old FDB files since my Win2000 (32 bit) days, and
unfortunately some of them are available only in FDB form, not as a
backup file.
Is there any way I can get access to them on my current 64 bit system
with only 64 bit Firebird installed?
The database file is binary
I've archived some old FDB files since my Win2000 (32 bit) days, and
unfortunately some of them are available only in FDB form, not as a
backup file.
Is there any way I can get access to them on my current 64 bit system
with only 64 bit Firebird installed?
The database file is binary
Hi all.
I have a question about how Firebird internally updates a record.
Here an example:
Create table test(cod integer, name varchar(50))
Commit;
Insert into test(cod, name) values (1, 'Big description 1');
Insert into test(cod, name) values (2, 'Big description 2');
Insert into
Hello, Fabiano!
Monday, May 21, 2012, 9:08:04 PM, you wrote:
F I have a question about how Firebird internally updates a record.
it uses versioning.
F Insert into test(cod, name) values (1, 'Big description 1');
F Insert into test(cod, name) values (2, 'Big description 2');
F Insert into
Dmitry thanks for answers. I understand fine.
But I made a new test:
After deleting cod=2, I make a backup with garbage collect set and do a
'select count(*) from test' to ensure all rows are touched.
Then:
Insert into test(cod, name) values (2, 'Small 2');
Again, it does not reuse the
Hello,
Our customers are complaining that there are lots of (GBs) temp files
written by Firebird in temp directory. Is there a way to have embedded
Firebird 2.5 to clean up temp files, e.g. lock files, after it's done
with them?
Thanks,
Alec
I found the following setting in
http://ibexpert.net/ibe/index.php?n=Doc.ConfiguringFirebird#FBConf:
TempDirectories = c:\temp 1
I am assuming that 1 is in bytes, correct? What happens when
this limit is reached?
Thanks,
Alec
On Mon, May 21, 2012 at 1:00 PM, Alec Swan
Alexey Kovyazin schrieb am 21.05.2012 um 15:04 (+0400):
You have hit transaction limit of Firebird.
To prevent it, make backup/restore more often.
What makes you think so? And why would that make the memory usage
rise to nearly 100% ? Also, the limit is 2**64, that's pretty high.
Re:
Hello, Fabiano!
Monday, May 21, 2012, 10:32:32 PM, you wrote:
F After deleting cod=2, I make a backup with garbage collect set and do a
Don't be mistaken. gbak -b makes select * from table
and this causes attempt server to check for a garbage and try to
collect it, and
gbak -b -g disables
Dmitry, I Just curious!
My application has a good transaction control and old record versions is not
a problem.
I read the this PDF http://www.firebirdsql.org/manual/fb-internals.html
http://www.firebirdsql.org/manual/fb-internals.html
and start making tests to see how this works.
I
Thanks Ann.
Really I think that it does not use free space very often because is not
ease of use as you say in topic 3.
I'm just curious!
[Non-text portions of this message have been removed]
Hello, Fabiano!
Monday, May 21, 2012, 11:49:01 PM, you wrote:
F I think Firebird uses the best approach for deleted records but I don't
F understand much why.
real SQL server must have transaction control and conform to ACID
requirements. It can be done by different mechanisms - locking,
18 matches
Mail list logo