Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?

2015-12-04 Thread Fabiano Kureck fabi...@sci10.com.br [firebird-support]
What you can do is inspect Firebird structure and search for an unused area. Documentation about this can be found at http://www.firebirdsql.org/manual/fb-internals.html By example if you check http://www.firebirdsql.org/manual/fbint-standard-header.html Pag_checksum: Two bytes, unsigned. Bytes

Re: [firebird-support] Upgrade from 2.5.2 to 2.5.4

2015-11-06 Thread Fabiano Kureck fabi...@sci10.com.br [firebird-support]
No. Only from 2.5.1 to another version. Em 05/11/2015 22:21, todd.brass...@yahoo.com [firebird-support] escreveu: Is a Backup and Restore Required?

Re: [firebird-support] Cannot Create Index

2015-10-13 Thread Fabiano Kureck fabi...@sci10.com.br [firebird-support]
Maximum key size is one quarter of page size. What is your database page size? What is the collation of that field? Try increase database page size to 16Kb Em 13/10/2015 12:20, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] escreveu: Hi All, I am trying to create index on a field

[firebird-support] Firebird

2015-07-24 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Você é Brasileiro? Estou acompanhando uma mensagem sua no grupo. Se falar português posso te ajudar melhor, por email, por aqui. --

Re: [firebird-support] Problem with FB database that freezes

2015-07-24 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Take at look at the HDD usage. Is HDD been used around 100% when slowly appears? On 24/07/2015 16:00, conver...@gmail.com [firebird-support] wrote: Thanks Thomas. Today we had a performance problem about 3 hours ago, we had to reboot the Windows server to solve it. Prior to the restart, the

Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)

2015-06-11 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
IMHO you have a corrupted database. You must use gfix to correct it (google it) and then your backup/restore cycle will be completed with no errors. On 11/06/2015 17:33, Jack Mason jackma...@mindspring.com [firebird-support] wrote: Why is everyone else not having this problem? The

Re: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

2015-06-03 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Do you HAVE a memory problem? Or are you upset about Firebird using this amount of RAM? On 03/06/2015 09:48, 'Jojakim Stahl' joja.li...@jojakim.de [firebird-support] wrote: Hello, still no solution. Running since last Friday, fbserver.exe grew up to +3GB memory so far. Few minutes ago, I

Re: [firebird-support] large system slows over time

2015-05-05 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Did you run a Sweep before backup? On 05/05/2015 08:02, Nick Upson n...@telensa.com [firebird-support] wrote: yes, large transaction gap was the first thing I checked Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On

Re: [firebird-support] large system slows over time

2015-05-05 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
May 2015 at 12:09, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br mailto:fabi...@sci10.com.br [firebird-support] firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com wrote: Did you run a Sweep before backup? ​no but then the backup does gc, I'm interested

Re: [firebird-support] Query to slow

2015-02-18 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
select in does not use indexes. Use EXISTS() instead. On 18/02/2015 11:25, martin_gorr...@yahoo.es [firebird-support] wrote: Hi; I am using FB 2.5.3. in a fast environment (win8 64bit - QuadCore 3.4 Ghz - 8 GB ram). If I run this query it goes very very fast and returns 84 records:

Re: [firebird-support] Re: Simultaneous inserts to the same table.

2015-01-21 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
---In firebird-support@yahoogroups.com, fabiano@... wrote : IMHO what is going on is that Firebird is using the lock file (for Classic installation) to synchronize between various connections (threads in this case) to allow one by one to write to FDB file. I hope that Vlad or Dmitry will

Re: [firebird-support] Simultaneous inserts to the same table.

2015-01-21 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
IMHO what is going on is that Firebird is using the lock file (for Classic installation) to synchronize between various connections (threads in this case) to allow one by one to write to FDB file. I also tested this and if you run various threads inserting among different tables there are no

Re: [firebird-support] FB 2.5.3 32bit and Db size limits test

2014-12-11 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
I have a database of 70Gb, more than 70% images, maybe you have a problem in your system as said before. On 11/12/2014 09:56, Daniel Rail dan...@accra.ca [firebird-support] wrote: Hi, What version of Firebird(Classic, SuperClassic, SuperServer or Embedded)? What is the page

Re: [firebird-support] Stability on newer windows ...

2014-11-19 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Currently, FB 2.1 is lo longer supported as older OSs. Maybe your problem was corrected in a newer FB version as FB 2.5.3 (that corrects a bug of caching on 64 bit Windows by example). IMHO, you need to switch to the lasted Firebird (2.5.3) and try again. On 19/11/2014 13:10, Lester Caine

Re: [firebird-support] Stability on newer windows ...

2014-11-19 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Try using the 32 bit version of Firebird, maybe this can help you. On 19/11/2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 19/11/14 17:15, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: Currently, FB 2.1 is lo longer supported

RES: [firebird-support] Have a lots memory, but FB could not take advantages

2013-07-15 Thread Fabiano Kureck
Just increase Page Buffers [Non-text portions of this message have been removed]

[firebird-support] Fluxo do software

2013-06-14 Thread Fabiano Kureck
Tenho algumas dúvidas quanto ao fluxo dos softwares: A princípio se usa um programa CAD (AutoCad, Solidworks, etc) para gerar o arquivo 3D .stl certo? Após isso se passa para no netfabb para que o arquivo stl seja preparado/compatível com uma impressão 3D. Então, passa-se pelo Slickr (algo

RES: [firebird-support] Fluxo do software

2013-06-14 Thread Fabiano Kureck
Sorry about that! I posted on wrong place... [Non-text portions of this message have been removed]

RES: [firebird-support] RDB$PAGES

2013-05-23 Thread Fabiano Kureck
Sorry is not rdb$database but another system table. I can´t remember its name… De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Norman Dunbar Enviada em: quinta-feira, 23 de maio de 2013 06:35 Para: firebird-support@yahoogroups.com Assunto: Re:

RES: [firebird-support] Re: use of -USE_ALL_SPACE

2013-05-03 Thread Fabiano Kureck
Yes, you are wright. And in a particular Page it is only allowed a single type of: Table Data or index or generator and so on -Mensagem original- De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de W O Enviada em: sexta-feira, 3 de maio de 2013 12:42

RES: [firebird-support] Re: use of -USE_ALL_SPACE

2013-05-03 Thread Fabiano Kureck
Enviada em: sexta-feira, 3 de maio de 2013 14:20 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Re: use of -USE_ALL_SPACE That's very interesting Fabiano, thank you very much for your answer. Greetings. Walter. On Fri, May 3, 2013 at 1:12 PM, Fabiano Kureck fabianoas

RES: [firebird-support] Re: How to read the Memory buffers size via SQL?

2013-04-25 Thread Fabiano Kureck
? --- In firebird-support@yahoogroups.com mailto:firebird-support%40yahoogroups.com , Fabiano Kureck wrote: Hi! I must read the Memory Buffers parameter from the database using sql. I know that I can use gfix to change and gstat to read. I want to read it via a sql command. How do

[firebird-support] How to read the Memory buffers size via SQL?

2013-04-24 Thread Fabiano Kureck
Hi! I must read the Memory Buffers parameter from the database using sql. I know that I can use gfix to change and gstat to read. I want to read it via a sql command. How do that? Thanks. [Non-text portions of this message have been removed]