[firebird-support] android version

2015-05-05 Thread craig_...@coxcolvin.com [firebird-support]
Does anyone know if there will be a mobile version of firebird soon?

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

2015-05-05 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
Hi Nick, I have a system that is slowing down the longer it stays running and I'd like to know why. ... Is there any evidence I can gather before I reboot the system which I expect (from past experience) will return the system to the better performance Hmmm If rebooting will

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

2015-05-05 Thread Jesus Garcia jeg...@gmail.com [firebird-support]
El 5/5/2015, a las 12:15, Nick Upson n...@telensa.com [firebird-support] firebird-support@yahoogroups.com escribió: Hi I have a system that is slowing down the longer it stays running and I'd like to know why. The system is running firebird 2.1.5 on centos 5 with an average of 27

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

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
On 5 May 2015 at 12:23, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] firebird-support@yahoogroups.com wrote: 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

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

2015-05-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 5-5-2015 12:15, Nick Upson n...@telensa.com [firebird-support] wrote: I have a system that is slowing down the longer it stays running and I'd like to know why. The system is running firebird 2.1.5 on centos 5 with an average of 27 transactions per second and has now been running for 112

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

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
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 5 May 2015 at 12:01, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] firebird-support@yahoogroups.com

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 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
Hi I have a system that is slowing down the longer it stays running and I'd like to know why. The system is running firebird 2.1.5 on centos 5 with an average of 27 transactions per second and has now been running for 112 days. The data throughput is unchanged, data is removed from the

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

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
On 5 May 2015 at 12:09, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] firebird-support@yahoogroups.com wrote: Did you run a Sweep before backup? ​no but then the backup does gc, I'm interested in why the suggestion, I can try it​ Nick Upson, Telensa Ltd, Senior

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

2015-05-05 Thread Nick Upson n...@telensa.com [firebird-support]
On 5 May 2015 at 12:12, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] firebird-support@yahoogroups.com wrote: How does your backup call look like? ​gbak, -user sysdba -pass x -backup hostname:/opt/pathtodb /pathto/backuparea ​ Nick Upson, Telensa Ltd, Senior Operations

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

[firebird-support] Performance question

2015-05-05 Thread 'checkmail' check_m...@satron.de [firebird-support]
Hello, the situation: state for each element (can be 0 or 1 for Example) = 1001000.. Is it faster to insert this in a varchar-field or is it better to store it in zwenty smallint separate database fields? I would like to analyze it later. (read substring or each field) Thanks in