Re: RES: RES: [firebird-support] Internal Firebird question.

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, versi

RES: [firebird-support] Internal Firebird question.

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]

RES: RES: [firebird-support] Internal Firebird question.

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 and start making tests to see how this works. I

Re: RES: [firebird-support] Internal Firebird question.

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 check

Re: [firebird-support] unable to allocate memory from operating system

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: [ib-s

Re: [firebird-support] Internal Firebird question.

Fabiano, There are several issues around reusing space from deleted records. 1) When you delete, what actually happens is that Firebird creates a new record version that indicates that the record is deleted (aka "deleted stub"), but does not actually delete the old record. If your transaction

[firebird-support] Re: Embedded Firebird leaves a lot of temp files behind

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 wrote: >

[firebird-support] Embedded Firebird leaves a lot of temp files behind

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

RES: [firebird-support] Internal Firebird question.

Forget! You right, it uses free space when the page are touched. I make a mistake. The old data continues on datapage but pointers are updated. Now it shows me 3 records. Thanks! De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Dmitry Kuzmenko Enviada

RES: [firebird-support] Internal Firebird question.

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 ol

Re: [SPAM 4] Re: [firebird-support] Access 32 bit DB on 64 bit system?

Den 2012-05-21 14:36 skrev Thomas Steinmaurer såhär: > > Forgot to mention, in case your database is using third-party 32-bit UDF > libraries, you need them in a 64-bit edition when accessing the database > via a 64-bit server. > Ah! That could be it, actually! I think I had an udf that I wrote in

Re: [firebird-support] Internal Firebird question.

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 te

[firebird-support] Internal Firebird question.

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 test

Re: [firebird-support] Re: gbak -c error of "size specificatation"

Kelly, > it's a very simple DB file. no external tables, nothing fancy. just > around 25 tables in the DB and 8 gigs of data. all straight ahead. not > even any embedded triggers or user-defined functions or anything. just > tables, fields, records. > If you haven't discarded the .fbk, you

RE: [firebird-support] Access 32 bit DB on 64 bit system?

Hi, you could just download the appropriate embedded Firebird distribution, use a database management tool of your choice, and then do a backup. If your database uses 32 bit UDFs, you're screwed. Regards, Alex

Re: [firebird-support] Access 32 bit DB on 64 bit system?

Den 2012-05-21 14:32 skrev Thomas Steinmaurer såhär: > > > 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 > >

Re: [firebird-support] Access 32 bit DB on 64 bit system?

>> 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

Re: [firebird-support] Access 32 bit DB on 64 bit system?

> 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 c

RE: [firebird-support] Access 32 bit DB on 64 bit system?

If you don’t 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 it’s free. I use it for such things. http://windows.microsoft.com/de-de/windows7/products/features/windows-xp-mod e

[firebird-support] Re: unable to allocate memory from operating system

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" wrote: > > Our main database is Firebird 2.1 running on a windows 2k8 server > > In t

[firebird-support] Access 32 bit DB on 64 bit system?

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 back

Re: [firebird-support] unable to allocate memory from operating system

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

Re: [firebird-support] unable to allocate memory from operating system

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 updati

[firebird-support] unable to allocate memory from operating system

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 turned off. P

Re: [firebird-support] Why does DISTINCT does not use the index in this simple case?

Hi, The times that I gave in my previous post are the times that are required to get the first 25 or so records. Sorry about the ambiguity. And yes, you are right to assume that the records are stored in Id order. Thanks a lot for your detailed answer. I think that I understand a bit better ho