patrickzurek
commented
8 years ago JIRA Comment by user: Chris Delis (cedelis) JIRA Timestamp: 2010-10-15 07:31 PM
Comment body:
records exported:
UIU bib 5,583,939 hold 6,635,919 auth 4,568,551 16,788,409
UIC bib 2,269,370 hold 2,634,031 auth 8,292,476 13,195,877
TOT 29,984,286
UIU + UIC bib 7,853,309 hold 9,269,950 auth 12,861,027 TOT 29,984,286
records loaded:
UIU+UIC bib 7,852,287 hold 9,264,747 auth 12,861,024 TOT 29,978,058
errors encountered during load:
bib 1015 hold 5198 auth 3 TOT 6216
errors encountered during conversion:
errors 10
loaded 29,978,058 errors 6,226 TOT 29,984,284
There was a total of 2 records unaccounted for out of almost 30 million.
INDEX TIME: 8 hr 55 min
INFO - [LIB] Conversion statistics summary: converted: 29984274, invalid: 10 records. It took 01:35:24.212 [Load 1] INFO - [LIB] Import statistics summary: created 29965785, updated: 0, skipped: 0, invalid: 6216, deleted: 0, bib: 7844413, auth: 12861024, holdings: 9260348 records. Invalid files: 1. It took 07:51:10.701. checkTime: 00:32:04.538. insertTime: 00:19:45.631. others: 06:59:20.532 [Load 2: Had to run it a second time to fix invalid file...] INFO - [LIB] Import statistics summary: created 12273, updated: 7727, skipped: 0, invalid: 0, deleted: 0, bib: 7874, auth: 0, holdings: 4399 records. Invalid files: 0. It took 00:00:22.300. checkTime: 00:00:02.654. insertTime: 00:00:00.920. others: 00:00:18.726
OPTIMIZE TIME: 1 hr 23 min (first optimize)
[Optimize 1] 2010-10-15 00:12:11,509 main INFO - [PRG] optimizing database... 2010-10-15 01:35:19,214 main INFO - [PRG] Import done [Optimize 2] 2010-10-15 08:59:22,180 main INFO - [PRG] optimizing database... 2010-10-15 10:23:31,410 main INFO - [PRG] Import done
TOTAL IMPORT TIME: 10 hr 18 min
JIRA issue created by: rcook Originally opened: 2010-10-05 05:17 PM
Issue body: