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
[email protected] [firebird-support]" <[email protected]>
escribió:
Guten Tag 'Costantino Molinari' [email protected] [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:[email protected]
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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
