@yahoogroups.com]
Inviato: mercoledì 1 ottobre 2014 11:29
A: firebird-support@yahoogroups.com
Oggetto: Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
Hi,
i test this on virtual machine with Windows 2008R2 and Xeon E5-2680 v2 and
result was
rd-support@yahoogroups.com
Oggetto: Re: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
>Obviously the logic of my application is not the best, but it needs to pass
>through a special interface, that transforms classic cobol read/write
>routines, in s
groups.com]
Inviato: lunedì 29 settembre 2014 14:52
A: 'Costantino Molinari' c.molin...@tiscali.it [firebird-support]
Oggetto: Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
Guten Tag 'Costantino Molinari' c.molin...@tiscali.it [f
Costantino
Mi recomendacion para realizar insert de gran cantidad de datos, es utilizar
tablas externas. Estas son extremadamente rapidas.Para esto
1 tenes que definir un archivo de texto con los datos. 2 crear la tabla externa
en firebird
3 realizar el insert a la tabla definitiba de los regis
Guten Tag 'Costantino Molinari' c.molin...@tiscali.it [firebird-support],
> To Karol:
> Original page size was 16K, than I changed page size to 4K just
> as my NTFS cluster size and time incredibly doubled !!
> Really confused, but maybe it has to do with the 64K stripe
29 settembre 2014 13:48
A: firebird-support@yahoogroups.com
Oggetto: Re: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
>Obviously the logic of my application is not the best, but it needs to pass
>through a special interface, that transforms c
>Obviously the logic of my application is not the best, but it needs to pass
>through a special interface, that transforms classic cobol read/write
>routines, in sql statements. This brings to the need to have a single
>commit after a single insert command of a single record. I know this is not
>g
prove Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
>Hi Sean, thanks for the contribution.
>
>Some answers to your requests:
>
>1) Logic of application.
>
>It is a Microfocus Cobol legacy application, with latest (2014) x64
runtime. The long time is obviously not relative to
Fabiano,
> Number of guaranteed writes is much lower on SSD.
**Not true** for all SSD/flash based devices.
Certainly true for low end/consumer Flash/SATA devices.
> when FB tries to write some write operations will fail and database will be
> corrupted.
Again, not true, as a broad statement.
>Hi Sean, thanks for the contribution.
>
>Some answers to your requests:
>
>1) Logic of application.
>
>It is a Microfocus Cobol legacy application, with latest (2014) x64 runtime.
>The long time is obviously not relative to a simple sql command, but to the
>overall execution.
>We have deve
Constantino, how many simultaneous users you have?
One thing that boosts database writes on large tables (tables not
databases) is changing database buffers.
Try increase to 2, restart your server or close and open all
connections and try again.
Em 28/09/2014 08:23, "Louis van Alphen lo...@nucl
We just deployed a new server RAID10 with 8 SSDs and want to make sure we dont
run into issues. I have scheduled a gbak every night, but that needs to be to
copied to other storage
Sent from my iPad
On 28 Sep 2014, at 12:57, "Ivan Arabadzhiev intelru...@yahoo.com
[firebird-support]" wrote:
>
I`ve been using SSDs for quite some time - had major issues with a Kingston
model a while back, so I`ve kept away from them. Most my servers are with
Corsair Force 3 drives and doing fine (they are UPS protected, so power
outages don`t happen all that often) - haven`t had a corruption during
normal
Number of guaranteed writes is much lower on SSD. when FB tries to write
some write operations will fail and database will be corrupted.
Flash disks as pen drives and memory cards also.
Em 28/09/2014 04:53, "Louis van Alphen lo...@nucleo.co.za
[firebird-support]" escreveu:
>
>
> Why will corrupti
Why will corruption occur?
Sent from my iPad
On 27 Sep 2014, at 19:03, "fabianoas...@gmail.com [firebird-support]"
wrote:
> Do not change to a SSD! Corruption will occur.
>
> Em 27/09/2014 11:16, "Doychin Bondzhev doyc...@dsoft-bg.com
> [firebird-support]" escreveu:
>
> Hi Costantino,
>
support (smaller index
deep)
Regards,
Karol Bieniaszewski
- Reply message -
Od: "'Costantino Molinari' c.molin...@tiscali.it [firebird-support]"
Do:
Temat: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows
server 2012 R2
Data: pt., wrz 26, 201
Do not change to a SSD! Corruption will occur.
Em 27/09/2014 11:16, "Doychin Bondzhev doyc...@dsoft-bg.com
[firebird-support]" escreveu:
>
>
> Hi Costantino,
>
> I did some experimenting before one year and I found that Firebird is
> much faster when you use page size = cluster size on the file s
Hi Costantino,
I did some experimenting before one year and I found that Firebird is
much faster when you use page size = cluster size on the file system.
So if your file system is with 4K cluster I suggest to use page size of 4K.
This is very helpful when you have Forced Write = ON.
Performan
to improve Firebird 2.5.3 Disk I/O on
Windows server 2012 R2
> Hello,
> I have installed Firebird 2.5.3 SuperServer x64 on a Windows server 2012 R2
> (x64).
> At the moment I have done no changes in firebird.conf
>
> Hardware resources are:
> 2 x 12core Intel Xe
> Hello,
> I have installed Firebird 2.5.3 SuperServer x64 on a Windows server 2012 R2
> (x64).
> At the moment I have done no changes in firebird.conf
>
> Hardware resources are:
> 2 x 12core Intel Xeon, 32 GB DDR3 Ram, 6 x 1.2TB SAS RAID 10, 1 GB Ram on
> 6Gbps RAID controller with Flash Backu
Hello,
I have installed Firebird 2.5.3 SuperServer x64 on a Windows server 2012 R2
(x64).
At the moment I have done no changes in firebird.conf
Hardware resources are:
2 x 12core Intel Xeon, 32 GB DDR3 Ram, 6 x 1.2TB SAS RAID 10, 1 GB Ram on
6Gbps RAID controller with Flash Backup and
21 matches
Mail list logo
