| | 46 | === Allie upload === #allieload |
| | 47 | |
| | 48 | 1. load file into ld_dir: |
| | 49 | |
| | 50 | nohup $VIRTUOSO_HOME/bin/isql 1111 dba dba <$VIRTUOSO_HOME/scripts/load.list.isql & |
| | 51 | |
| | 52 | load.list.isql: |
| | 53 | |
| | 54 | {{{ |
| | 55 | delete from load_list; |
| | 56 | ld_dir('/opt/services/togordf/data/allie','x*.rdf.nt','http://allie.dbcls.jp'); |
| | 57 | select * from load_list; |
| | 58 | }}} |
| | 59 | |
| | 60 | |
| | 61 | 2. upload the file into virtuoso: |
| | 62 | nohup $VIRTUOSO_HOME/bin/isql 1111 dba dba <$VIRTUOSO_HOME/scripts/load.data.isql & |
| | 63 | |
| | 64 | load.data.isql: |
| | 65 | |
| | 66 | {{{ |
| | 67 | --record CPU time |
| | 68 | select getrusage ()[0] + getrusage ()[1]; |
| | 69 | |
| | 70 | rdf_loader_run () & |
| | 71 | ...(omit 10 times) |
| | 72 | rdf_loader_run () & |
| | 73 | checkpoint; |
| | 74 | |
| | 75 | -- Record CPU time |
| | 76 | select getrusage ()[0] + getrusage ()[1]; |
| | 77 | |
| | 78 | }}} |
| | 79 | |
| | 80 | |
