I think Kurt's on to something there. With an index on a lot of the fields, an APPEND/REPLACE forces the indexes to be updated twice (more if there are separate REPLACE statements), while an INSERT INTO only does it once.
Fred On Fri, Feb 22, 2013 at 7:20 AM, Jeff Johnson <[email protected]> wrote: > I have a very strange problem. It is an application that uses append and > gather. June of last year their system started creating orders with blank > information in them. Mainly dispatcher. They call them phantom orders. > There is no rhyme or reason for them to appear, but 40% of their overall > orders since then. They wrote a routine to zero out the numbers and delete > them but it is annoying because they show up and then the purge routine > removes them and the users see this. There are about 100 users. > > The only thing that I found that is unusual is that the order table was > indexed on every field with the invoice field descending. Could this cause > problems when adding new records? > > Thanks in advance, > > -- > Jeff > > --------------- > > Jeff Johnson > [email protected] > (623) 582-0323 > > www.san-dc.com > www.arelationshipmanager.com > > > ______________________________**_________________ > Post Messages to: [email protected] > Subscription Maintenance: > http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox> > OT-free version of this list: http://mail.leafe.com/mailman/** > listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech> > Searchable Archive: > http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox> > This message: http://leafe.com/archives/**byMID/profox/51277ECB.4050000@** > san-dc.com<http://leafe.com/archives/byMID/profox/[email protected]> > ** 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. > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksrgf4x1oje5hin1rzvoudvcy0ran9xk2_xc7u0rwnh...@mail.gmail.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.
