Subject Re: R: [firebird-support] How to improve Firebird 2.5.3 Disk I/O on Windows server 2012 R2
Author Germán Balbi
Post date 2014-09-29T14:34:25Z
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 registros de tu interes

Saludos

Google translate

My recommendation for insert large amount of data, is to use external tables. These are extremely fast.

for this

One got to define a text file with the data.

2 create the external table in firebird

3 to perform the insert table definitiba records of your interest


El Lunes, 29 de septiembre, 2014 9:52:42, "Hannes Streicher hstreicher@... [firebird-support]" <firebird-support@yahoogroups.com> escribió:


Guten Tag 'Costantino Molinari' c.molinari@... [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 size of RAID 10….

Not surprisiing at all, Stripe Set is the amount of Data a RAID moves for every read/write
so if you have 16 KB or 4KB you still move 64KB each time but with much less usable Payload per transfer
go for a Stripsetsize of 16 KB and a Pagesize of 16KB for best match


--
Mit freundlichen Grüssen
Hannes Streicher                            mailto:HStreicher@...




------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/