dear all,I’m planning to develop a system to import data from oracle…i need to know the best method(fast)
use multivalue fields using an array
create documets for each record and display using views
plese tell me which method is the fastest
thanks in advance
shana
Subject: import data from oracle
It’s not a matter of performance – it’s capacity. Multivalue fields will not allow you to import more than a handfull of records in a useful way. Not only does each field have a limited capacity, but there is a summary data limit for the entire document as well.
Subject: RE: import data from oracle
thanks for your response assuming i have about 200 records…thought creating documents, more time consuming rather than displaying on multivalue fields.
shana
Subject: RE: import data from oracle
Couple of things - you may want to check out the Enterprise Integration forum since it’s focused on just this issue.
200 docs is nothin’. I do an hourly pull from our ERP system to get current part numbers and recent orders. The dbs that do these imports contain 50K docs now. I only pull in 20 or less per hour as changes are made in Oracle, but the intial load only took 15 minutes or so (and I do one Notes doc per Oracle record).
On the other hand, if you’re doing a complex query, the query may take a long time to execute but that’s totally separate from creating the Notes doc which will be pretty fast.
HTH.
Doug
Subject: thanks a lot
Subject: RE: import data from oracle
Well, you only get 64KB of summary data per document. That includes the system fields that Notes will add automatically. 64KB only gives you a little over 300 bytes for each of those 200 records – which is probably a tighter limit than you were expecting. Use separate documents.
Subject: thanks