I was unable to use insert with memo fields so I used append blank & gather memo. This worked fine on the small files but my concern was two huge files. One was a dbf and the other was an Access table. When I converted the Access data I used nvl() on each field. I also appended blank and gathered on a temporary file created with copy structure. This allowed me to add records without updating the indexes (which I have many - I use the VMP framework).
Doing the above I was able to take the import for almost two hours down to 5 1/2 minutes! Thanks all. Jeff --------------- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 10/25/2011 11:24 AM, Jeff Johnson wrote: > On 10/25/2011 10:59 AM, Richard Quilhot wrote: >> Have you thought about doing the other way? >> Using the "append from" command. >> >> Rick Q >> quilh...@gmail.com >> >> >> >> >> On Tue, Oct 25, 2011 at 1:49 PM, Jeff Johnson<j...@san-dc.com> wrote: >> >>> On 10/25/2011 10:23 AM, Fred Taylor wrote: >>>> I just tried a SCATTER MEMO NAME test from origtable and then did a >>> INSERT >>>> INTO newtable FROM NAME test and it worked fine. >>>> >>>> Are you sure you've got the same structures in your tables? Possibly a >>>> field name that's a reserved word? >>>> >>>> Fred >>>> >>>> >>>> On Tue, Oct 25, 2011 at 10:04 AM, Jeff Johnson<j...@san-dc.com> wrote: >>>> >>>>> I am importing a very large database from one version of a table to >>>>> another version of a table with a few conversions. I use the scatter >>>>> name object blank and fill the objects with the data I want. Then I do >>>>> an append blank and gather name object. This works fine. I wanted to >>>>> speed things up by using an insert into. >>>>> >>>>> I tried scatter memo name object and then doing a insert into newtable >>>>> from name o and I get a data type mismatch on the insert. It appears to >>>>> be from the memo field. >>>>> I tried scatter name object and then insert into newtable from name o >>>>> and got the same message. >>>>> >>>>> Is there any way to optimize this when using a memo field? There are 72 >>>>> fields and I don't really want to go the route of a full insert into >>>>> command. >>>>> >>>>> Any ideas? >>>>> >>>>> -- >>>>> Jeff >>>>> >>>>> --------------- >>>>> >>>>> Jeff Johnson >>>>> j...@san-dc.com >>>>> (623) 582-0323 >>>>> >>>>> www.san-dc.com >>>>> >>>>> >>> That helped Fred. I was using the same object reference for two >>> different tables. ;^) >>> >>> >>> Jeff >>> >>> --------------- >>> >>> Jeff Johnson >>> j...@san-dc.com >>> (623) 582-0323 >>> >>> www.san-dc.com >>> >>> >>> > > Richard: I just came to that conclusion. I am going to create a > temporary table with a copy structure and fill the temporary table > because it has no indexes. Then I will do an append from and it should > speed it up significantly. > > Thanks, > > Jeff > > --------------- > > Jeff Johnson > j...@san-dc.com > (623) 582-0323 > > www.san-dc.com > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4ea7590f.5010...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
