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
good,
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
good,
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
.
To Set:
TERM SET^ suggestion worked fine.
Time of
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
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
Dear Hannes,
good suggestion, but changing the stripe size is not for me now, if I don't
want to install all again, if I'll be able to obtain an acceptable speed
with other settings.
-Messaggio originale-
Da: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]