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 hstreic...@gmx.de [firebird-support]" <firebird-support@yahoogroups.com> escribió: 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 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:hstreic...@gmx.de ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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