Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread fabianoas...@gmail.com [firebird-support] 
Eduardo. You problem only will be solved by turning on write cache if
possible or switching to a new cache write enabled server. Dot.
Do not change anything in your software.
Em 30/12/2015 12:15, "Eduardo guse...@gmail.com [firebird-support]" <
firebird-support@yahoogroups.com> escreveu:


>
>
> I read that disabling forced writes is not safe.
>
> But there is something that I really don´t understand.
>
> If I disable forced writes, then when I make commits, data goes to the RAM
> of the server and afterwards, in some moment, the data will be physically
> written to the database.
>
> If I enable disk write cache, then things happen the same way. So, what is
> the difference?
>
> From what I read, I think the difference is that with disk write cache,
> Windows manages when to physically write the data but, when disabling
> forced writes it is not guaranteed that Windows will physically write the
> data. Is this true?
>
> Another question. Why is so different the performance with disk write
> cache enabled or disabled? Is this something that happens in every RDBMS or
> is just a Firebird problem?
>
> Regards
>
> Eduardo
>
>  Mensaje original 
> *Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows
> Server 2012
> *De: *Ann Harrison aharri...@ibphoenix.com [firebird-support]
>  
> *Para: *firebird-support@yahoogroups.com
>  
> *Fecha: *29/12/2015 17:26
>
>
> On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl [firebird-support] <
> firebird-support@yahoogroups.com> wrote:
>
>>
>>
>> Do I have to change any configuration or the matter is that if I can´t
>> enable disk cache, there is nothing I can do to improve the performance?
>>
>> Try to disable force write on that database.
>>
>
> After you have a UPS installed and an aggressive backup schedule.
>
> Good luck,
>
> Ann
>
>
>
> 
>  Este
> correo electrónico se ha enviado desde un equipo libre de virus y protegido
> por Avast.
> www.avast.com
> 
>
>

RE: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Suporte TGA Rio Verde - GO suportetga...@outlook.com [firebird-support] 
Olha aqui já tivemos esse problema. Apenas liberamos as portas do firebird  no 
firewall do Windows server 2012 funcionou.
Libera as portas 3050 e 3051 tpc e udp, entrada e saída, tenho certeza que vai 
funcionar.

Desculpa mas não escrevo muito bem em inglês então escrevi em português mesmo.
  Adalton Batista (64) 3612-0066 / 3623-0646
 www.tgasistemasrv.com.br http://www.tgasistemas.com.br/

suportetga...@outlook.com
 ryle...@gmail.com mailto:ryle...@gmail.com

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
Thank you for the link. I read it but they don´t ensure that in a second 
disk you can enable write cache. Anyway on this server there is only one 
disk.


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com 
*Fecha: *30/12/2015 16:58




> The other is the fact that PDC machine will always have write cache 
disabled.


It seems that this is not true for all disks attached to PDC server, 
only to boot/Windows drive.


https://social.technet.microsoft.com/Forums/windowsserver/en-US/16352eee-6bc6-4858-8642-12b2496d39ee/how-to-enable-write-caching-on-domain-controller?forum=winserverDS 




Sean






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
I know, but that's impossible to do on that server. So the only solution 
I found so far is to install the application in another computer.


But anyway I would like to understand why this is necessary in Firebird. 
It would be great if anybody knows the answers to my questions of my 
previous message.


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *fabianoas...@gmail.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com
*Fecha: *30/12/2015 11:57


Eduardo. You problem only will be solved by turning on write cache if 
possible or switching to a new cache write enabled server. Dot.

Do not change anything in your software.

Em 30/12/2015 12:15, "Eduardo guse...@gmail.com 
 [firebird-support]" 
> escreveu:


I read that disabling forced writes is not safe.

But there is something that I really don´t understand.

If I disable forced writes, then when I make commits, data goes to
the RAM of the server and afterwards, in some moment, the data
will be physically written to the database.

If I enable disk write cache, then things happen the same way. So,
what is the difference?

From what I read, I think the difference is that with disk write
cache, Windows manages when to physically write the data but, when
disabling forced writes it is not guaranteed that Windows will
physically write the data. Is this true?

Another question. Why is so different the performance with disk
write cache enabled or disabled? Is this something that happens in
every RDBMS or is just a Firebird problem?

Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in
Windows Server 2012
*De: *Ann Harrison aharri...@ibphoenix.com
 [firebird-support]


*Para: *firebird-support@yahoogroups.com



*Fecha: *29/12/2015 17:26

On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl
 [firebird-support]
> wrote:




Do I have to change any configuration or the matter is that
if I can´t enable disk cache, there is nothing I can do to
improve the performance?


Try to disable force write on that database.


After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann




Este correo electrónico se ha enviado desde un equipo libre de
virus y protegido por Avast.
www.avast.com









---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
No, this is not the solution. One of the firs things I do when I install 
my application is to create firewall rules for ports 3050 and 3051. In 
this case I even deactivate the firewall but nothing changed.


My english is not perfect, but I can´t write in portuguese!


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Suporte TGA Rio Verde - GO suportetga...@outlook.com 
[firebird-support] 

*Para: *firebird-support@yahoogroups.com
*Fecha: *30/12/2015 07:24
Olha aqui já tivemos esse problema. Apenas liberamos as portas do 
firebird no firewall do Windows server 2012 funcionou.
Libera as portas 3050 e 3051 tpc e udp, entrada e saída, tenho certeza 
que vai funcionar.


Desculpa mas não escrevo muito bem em inglês então escrevi em 
português mesmo.

*Adalton Batista*
(64) 3612-0066 / 3623-0646
*www.tgasistemasrv.com.br *
suportetga...@outlook.com
ryle...@gmail.com 






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

RE: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 


> The other is the fact that PDC machine will always have write cache disabled.

It seems that this is not true for all disks attached to PDC server, only to 
boot/Windows drive.

https://social.technet.microsoft.com/Forums/windowsserver/en-US/16352eee-6bc6-4858-8642-12b2496d39ee/how-to-enable-write-caching-on-domain-controller?forum=winserverDS


Sean

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

[firebird-support] Install 2.5.5 on Debian 7 problem with APT

2015-12-30 Thread John vd Waeter j.v.d.wae...@kpnplanet.nl [firebird-support] 
Hi All,

I tried to upgrade my debian 2.5.2 FB-server to 2.5.5 and used the 
instructions to add a repository to APT like this:

sudo add-apt-repository ppa:mapopa

All ok, no errors reported.

but apt-get update gives me:


W: Failed to fetch 
http://ppa.launchpad.net/mapopa/ppa/ubuntu/dists/wheezy/main/
source/Sources  404  Not Found

W: Failed to fetch 
http://ppa.launchpad.net/mapopa/ppa/ubuntu/dists/wheezy/main/
binary-amd64/Packages  404  Not Found

W: Failed to fetch 
http://ppa.launchpad.net/mapopa/ppa/ubuntu/dists/wheezy/main/
binary-i386/Packages  404  Not Found

E: Some index files failed to download. They have been ignored, or old 
ones used instead.


Am I doing something wrong?

tia,
John

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 

I read that disabling forced writes is not safe.

But there is something that I really don´t understand.

If I disable forced writes, then when I make commits, data goes to the 
RAM of the server and afterwards, in some moment, the data will be 
physically written to the database.


If I enable disk write cache, then things happen the same way. So, what 
is the difference?


From what I read, I think the difference is that with disk write cache, 
Windows manages when to physically write the data but, when disabling 
forced writes it is not guaranteed that Windows will physically write 
the data. Is this true?


Another question. Why is so different the performance with disk write 
cache enabled or disabled? Is this something that happens in every RDBMS 
or is just a Firebird problem?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Ann Harrison aharri...@ibphoenix.com [firebird-support] 


*Para: *firebird-support@yahoogroups.com 
*Fecha: *29/12/2015 17:26
On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl 
 [firebird-support] 
> wrote:





Do I have to change any configuration or the matter is that if I
can´t enable disk cache, there is nothing I can do to improve the
performance?


Try to disable force write on that database.


After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus