Hi people, Firstly, I'd like to say that we are facing many performance troubles because of that... I'd like to know if there is a better way to implement ARCHIVE feature in an Application/Form that contains a high number of records - more than 2 million. We are searching for alternatives to do a initial load of data in our Archive Forms. Considering that if there is more than 2 million records saved in that form we wouldn't simply enable Archive feature (this would take much time) Here are our attempts about this: 1) - Enable Archive feature in a Form "X" (i.e. Create "X_ARCHIVE" Form) - Insert data in an Archive Form using Java API (arapi70.jar) Result: Unfortunatly, this tip didn't work fine. Archives form doesn't support create or modify entries. ERROR MESSAGE: "Cannot modify or create entries in an Archive or Audit form." [8998] 2) - Enable Archive feature in a Form "Y" (i.e. Create "Y_ARCHIVE" Form) - Create a Filter / Escalation that executes 'Push Fields' action periodically Result: Unfortunatly, this tip didn't work fine too. Considering that Archives form does not support create entries. 3) - Use SQL Commands and/or Oracle Database functions??? Maybe! I'd like to hear some suggestions of all of you... Thanks a lot!!! Tadeu Augusto Dutra Pinto ----------------------------------------------------------------- IT Web Services ATM Cinq Technologies http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq ----------------------------------------------------------------- Confiabilidade, Inovação e Qualidade em T.I.
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
