[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] Re: FB 2.1 CS High FBLockPrint Mutex wait figure

2015-06-18 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Also try to change the LockHashSlots in your Firebird.conf to: LockHashSlots=20011 Restart Firebird(or computer) and maybe you will have a lower % On 18/06/2015 14:51, 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] wrote: So I have upgraded to v2.5.4 CS 64 bit and it looks promising

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 databases

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 sto

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

2015-05-05 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
In my experience, GC collected by the gbak is different from sweep. I also have a problem with only my big customer (35Gb database) when the system become slow and slow over time. The solution was do a gbak with Garbage collect and then a sweep after. First time you do this it will take probab

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] Re: 64-bit server/32-bit application

2015-03-06 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
64bit server must use 64 bit dll. 32bit server must use 32 bit dll. Clients doesn't use UDF directly. If you have a 32 bit client you must use 32bit fbclient.dll. If you have a 64 bit client you must use 64bit fbclient.dll On 06/03/2015 10:34, jakef...@yahoo.com [firebird-support] wrote: Th

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

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, 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 tell us ho

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 per

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 cache/buffers(r

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

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 les

Re: [firebird-support] Firebird 2.5.2 and .3

2014-11-12 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
IMHO, this is due Windows caching. Even if you shutdown Firebird server not all memory will be freed. IMO, this is not a problem. If you are experiencing crashes this will be associated with other things. Please describe more precisely what is the crash. On 12/11/2014 08:46, Gerhard Knapp gerh